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