timeSlipColumns.addElement("StartTime");
timeSlipColumns.addElement("EndTime");
timeSlipColumns.addElement("Duration");
TimeSlipList timesliplist = new TimeSlipList();
ListGenerator lg = ListGenerator.getListGenerator(dataSource);
String searchTimeSlipString = "ADVANCE:select ts.TimeSlipID, ts.Description, ts.CreatedBy, individual.FirstName," + "individual.LastName, ts.BreakTime, ts.Date, ts.Start, ts.End " + "from timeslip ts left outer join individual on " + "ts.CreatedBy = individual.IndividualID where ts.ticketid=" + ticketID;
timesliplist = (TimeSlipList)lg.getTimeSlipList(individualID, 1, 200, searchTimeSlipString, "Description");
timesliplist = setTimeSlipLinks(timesliplist, ticketID);
Vector expenseColumns = new Vector();
expenseColumns.addElement("Reference");
expenseColumns.addElement("Amount");
expenseColumns.addElement("Created");
expenseColumns.addElement("Creator");
ExpenseList expenselist = new ExpenseList();
String searchExpenseString = "ADVANCE:select expense.ExpenseID,expense.Amount,expense.Created," + "entity.name as Reference ,expense.Status, concat(individual.firstname,' ',individual.lastname) " + "as Creator,individual.IndividualID " + "from expense left outer join individual on expense.creator = individual.individualid "
+ "left outer join entity on expense.entityid = entity.entityid " + " where expense.linestatus != 'deleted' and expense.ticket=" + ticketID + " group by expense.ExpenseID,expense.Amount," + "expense.Created,Reference ,expense.Status, Creator";
expenselist = (ExpenseList)lg.getExpenseList(individualID, 1, 200, searchExpenseString, "Reference");
expenselist = setExpenseLinks(expenselist, ticketID);
request.setAttribute("closeDate", tVO.getCloseDate());
request.setAttribute("openDate", tVO.getCreatedOn());
request.setAttribute("modifyDate", tVO.getModifiedOn());