Hi all, I having some issues using the "belongs" function of the DAL.
I'm trying to get the entry of the logs that has had no entry with logtype==3 yet on the current "iteration_max", but only one or more entries with logtype==10 and a timestamp that is older than the timeout in seconds, given with "myTimeout". Is there any way to get this working? thanks in advance! [code] myID=0 # some dummy ID... finished_tasks = db((db.MyLogs.run== myID) & (db.MyLogs.logtype==3))._select(db.MyLogs.iteration_max) import datetime timeout = datetime.datetime.now() timeout = timeout-datetime.timedelta(seconds=myTimeout) unfinished_tasks = db((db.MyLogs.run== myID) & (db.MyLogs.timestamp>timeout) &(db.MyLogs.logtype==10) & ((db.MyLogs.iteration_max.belongs(finished_tasks)).__invert__() ) ).select(db.MyLogs.iteration_max,orderby=db.MyLogs.iteration_max,limitby=(0,1)) [/code]
