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