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 >>>>> >>>>
--
