database views and webobojects
database views and webobojects
- Subject: database views and webobojects
- From: Theodore Petrosky <email@hidden>
- Date: Sat, 12 Jun 2010 08:00:42 -0700 (PDT)
How would I do something like this in WO?
two tables t_e_time, t_user
I have been hacking on both the qualifier and sort to see where I could create the group by clause...
this is what I want to accomplish...
SELECT t1.c_user_id, sum(t1.c_amount_of_time), t2.c_first_name, t2.c_last_name
FROM t_e_time t1
JOIN t_user t2
ON t1.c_user_id = t2.id GROUP BY t1.c_user_id, t2.c_first_name, t2.c_last_name;
I found ERXGroupingFetchSpecification but I can not find an example and without that I am lost...
I expect that eventually I should move this to a procedure on the database to speed it up.. but maybe this will do just fine...
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden