Displaying 1 result from an estimated 1 matches for "durationinhrs".
2006 Aug 09
0
Sum/Aggregate at database level or in rails controller?
Hi,
Database model of my web app is as follows,
users(id,name)
Taskcategories(id,user_id,name)
Tasks(id,taskcategory_id,name)
TasksData(id,tasks_id,durationInHrs,date)
I want to collect and show following data from the above tables, in the
view,
1. Category wise duration total for a user for a week.
2. Category wise duration total for a user for each of the 7 days of the
week.
3. Total duration for a particular week for all categories of a user.
4. Total...