Yes, working now. Thanks for that Massimo, really appreciate it. -Jim
On Wednesday, January 30, 2013 9:29:55 AM UTC-6, Massimo Di Pierro wrote: > > Can you please check again. I have added the suggested fix you suggested. > > On Wednesday, 23 January 2013 09:05:40 UTC-6, Jim S wrote: >> >> 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 >>>>>>>> >>>>>>> -- >>> >>> >>> >>> >> >> -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
