2.4.1-alpha.2+timestamp.2013.01.23.08:17:15 Just updated this morning.
-Jim On Wed, Jan 23, 2013 at 8:55 AM, Massimo Di Pierro < [email protected]> wrote: > Which version? I thought we fixed this in trunk. > > > On Wednesday, 23 January 2013 08:54:38 UTC-6, Jim S wrote: >> >> Oh, and the problem is that the grid only displays the data from the >> primary table. The join 'works', but there is no data for the joined >> tables in the grid. >> >> -Jim >> >> On Wednesday, January 23, 2013 8:53:55 AM UTC-6, Jim S wrote: >>> >>> Just updated to the latest version and am still having this problem. To >>> be specific, I can do this: >>> >>> query = (db.feedLoad.deliverOn==datetime.datetime.today())&(db.feedLoad. >>> siteId==1) >>> >>> left = [db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId >>> ), >>> db.feedOrderLine.on(db.feedOrder.feedOrderId==db.feedOrderLine. >>> feedOrderId)] >>> >>> rows = db(query).select(db.feedLoad.ALL, db.feedOrder.ALL, db. >>> feedOrderLine.ALL,left=left) >>> for row in rows: >>> print row >>> >>> >>> >>> >>> But I can't do this: >>> >>> query = (db.feedLoad.deliverOn==datetime.datetime.today())&(db.feedLoad. >>> siteId==1) >>> >>> fields = [db.feedLoad.siteId, db.feedOrderLine.productSiteId, db. >>> feedLoad.deliverOn, db.feedLoad.loadNumber, >>> db.feedOrder.customerName, db.feedOrder.customerCityState, >>> db.feedOrder.dropShipName, db.feedOrder.dropShipCityState, >>> db.feedLoad.driverId, db.feedOrder.orderNumber, >>> db.feedOrderLine.productNumber, db.feedOrderLine.productName] >>> >>> left = [db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId >>> ),db.feedOrderLine.on(db.feedOrder.feedOrderId==db.feedOrderLine. >>> feedOrderId)] >>> >>> grid = SQLFORM.grid(query, fields=fields, left=left, >>> create=False, deletable=False, >>> details=False, csv=False, >>> editable=False, searchable=False, >>> paginate=200) >>> >>> >>> >>> >>> >>> It would be great to get this working or let me know what I'm doing >>> wrong with my grid. >>> >>> Thanks - Jim >>> >>> On Friday, January 18, 2013 8:25:01 AM UTC-6, Jim S wrote: >>>> >>>> I just saw this post as well: >>>> https://groups.google.com/forum/#!topic/web2py/T1TkWEu2cX4 >>>> >>>> Can we get his fix implemented? >>>> >>>> -Jim >>>> >>>> On Friday, January 18, 2013 8:21:35 AM UTC-6, Jim S wrote: >>>>> >>>>> I tried that, but then I don't get any of my joined fields in the >>>>> result. Here is what I used for the join. >>>>> >>>>> left = >>>>> [db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId), >>>>> >>>>> db.feedOrderLine.on(db.feedOrder.feedOrderId==db.feedOrderLine.feedOrderId)] >>>>> >>>>> I get no fields from either feedOrder or the feedOrderLine tables, >>>>> only fields from feedLoad. >>>>> >>>>> -Jim >>>>> >>>>> On Friday, January 18, 2013 5:39:03 AM UTC-6, DenesL wrote: >>>>>> >>>>>> Hi Jim, >>>>>> >>>>>> from the book: >>>>>> "Multiple left joins can be combined by passing a list or tuple of >>>>>> db.mytable.on(...) to the left attribute." >>>>>> >>>>>> Denes >>>>>> >>>>> -- > > > > --
