Interesting, what would be the possibility of adding this as a feature to the new dal?
-- Thadeus On Tue, Apr 13, 2010 at 5:06 AM, canna <[email protected]> wrote: > Hello everybody! > > I really need help with a query I'm trying to execute in Web2Py DAL > is there a way to use an inline table in the FROM field of a query? > > this is my query: > > > SELECT SUM( HoursWorked / DayHoursSum ) AS DaysWorked > FROM `Tasks_TimeLog` H, ( > > SELECT TheDate, User_id, SUM( HoursWorked ) AS DayHoursSum > FROM `Tasks_TimeLog` > GROUP BY TheDate, User_id > )S > WHERE H.User_id = S.User_id > AND H.TheDate = S.TheDate > AND Task='2' > GROUP BY Task > > this is the inline table in Web2py: > > inlineTable=db()._select(db.Tasks_TimeLog.TheDate,db.Tasks_TimeLog.User_id,db.Tasks_TimeLog.HoursWorked.sum(),groupby=db.Tasks_TimeLog.TheDate| > db.Tasks_TimeLog.User_id) > > how do I use the inline table in my full query?? > > rows=db(db.Tasks_TimeLog.Task=='2'.....).select(.....,groupby=db.Tasks_TimeLog.Task) > > Thanks to all the helpers!! > > > > -- To unsubscribe, reply using "remove me" as the subject.
