Actualy it worked but not for reason i expected. Ill run some more tests here and let you know.
On Wednesday, March 27, 2013 1:03:26 PM UTC-3, Massimo Di Pierro wrote: > > 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.