Hi,
i need a query that can you modify according to me please.
for this query i am getting the result
select task_date, sum(hours_spent)as hours_spent1 from ip_timesheet where task_date between date('"+starDate +"', 'mm/dd/yyyy') and date('"+endDate+"', 'mm/dd/yyyy') group by select_date
That means it is adding up the housr_spent that an employee worked on that date.Hear i am saving like for example
an employee spent on task one for 2hour , and on second task he spent on 4 hours , i am getting total hours on that day by the above query.
2)The porblem is i need to add some more attributes for this query like
select task_name,task_description,comments,task_date,task_name,work_description, sum(hours_spent)as hours_spent1 from ip_timesheet where task_date between date('"+starDate +"', 'mm/dd/yyyy') and date('"+endDate+"', 'mm/dd/yyyy') group by select_date
How can i modify the query to meet my requierments.
Thanking You,
Rajesh.c
