[web2py] query from sql to code in web2py

[Annet]

I have the following where close in a query:

WHERE nodeid=283 and ((dayid=6 and starttime>'11:00:00')or(dayid>6));

In Postgresql this query outputs the right data.

I translated this query into the following code in a function:

rows=db((db.Timetable.nodeID==session.id)&(((db.Timetable.dayID==6)&(db.Timetable.startTime>'11:00:00'))or(db.Timetable.dayID>6))).select()

In web2py this code results in an empty rows object. What's the correct 
syntax for this query?


Kind regards,

Annet.