Please open a ticket about this and include the patch. I will review it and apply it asap.
Massimo On Wednesday, 27 March 2013 10:57:54 UTC-5, Felipe Meirelles wrote: > > 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.