What is happening is the complete oposite. Its aplying to the leftjoin table, but not to the main table.
The problem is on dal.py line 1553: tables_to_merge.keys() contains the main table, so the main table is not put on excluded var in line 1567 and therefore is not used on line 1574 to set the common filters. I patched it adding excluded + tablenames on line 1572 Can some one else test it and see if it will not impact on other places? On Wednesday, March 27, 2013 12:40:10 PM UTC-3, Massimo Di Pierro wrote: > > yes. I believe common filter are ignored for left joins. > > https://code.google.com/p/web2py/issues/detail?id=992&q=common > > On Wednesday, 27 March 2013 09:13:20 UTC-5, Felipe Meirelles wrote: >> >> I'm facing a problem where if I have something like this: >> >> grid = SQLFORM.grid(db.table1, >> left=[db.table2.on(db.table2.id==db.table1.reference)], >> ) >> >> my common filters are not processed for table1, only for table2! >> including is_active filter for version recording. >> >> Is there a bug? >> > -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.