Added a ticket with the patch that worked for me. Thanks! On Wednesday, March 27, 2013 1:05:22 PM UTC-3, Felipe Meirelles wrote: > > 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.
