Hello Anthony, Richard: Here is a link to download a demo app: https://c.gmx.net/@316857413586131071/y6xMeU53Ql2MtJz-wr0-CQ Just install it, on the main page click the link. I just did the input written in the very first post. Additionally I attached a screenshot showing my result.
Many thanks to You. Andreas Am Donnerstag, 8. März 2018 16:55:06 UTC+1 schrieb Anthony: > > On Thursday, March 8, 2018 at 10:28:38 AM UTC-5, Leonel Câmara wrote: >> >> Record versioning uses a common filter. >> >> Common filters do not work if you do not provide a query which is what >> happens when you do: >> >> db().select(db.test.ALL) >> >> You need to do: >> >> db(db.test.id > 0).select(db.test.ALL) >> > > I believe the query in question is: > > query = (test2.type_marker=='object') | (test2.type_marker==None) & (test1 > .type_marker=='person') > rows = current.db(query).select(test1.title, test2.title, left=test2.on( > test1.id==test2.granny)) > > So, there is a query being passed to db(). > > Anthony > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
