Then perhaps I am wrong. Still open a ticket about this. I will debug it
asap but I do not want to forget about this.
On Sunday, 3 June 2012 11:56:19 UTC-5, weheh wrote:
>
> Hmm, from researching the forum on the topic and reading the doc I could
> have sworn that smartgrid supported left. In fact, I believe in my testing
> I have seen it respond appropriately to the left argument. Nevertheless, I
> changed my code back to grid (I had started out with grid and moved to
> smartgrid). Now it looks like this, but produces the same "unsupported
> query" error message:
> grid = SQLFORM.grid(
> query,
> left=db.brand.on(
> (auth.accessible_query('read', db.brand,
> auth.user_id)) &
> (db.brand.id == db.url_queue.brand_id)
> ),
> fields=[
> db.url_queue.brand_id,
> db.url_queue.host_id,
> db.url_queue.mail_cnt,
> db.url_queue.url,
> db.url_queue.status,
> ],
> headers={
> 'url_queue.brand_id': 'Brand',
> 'url_queue.host_id': 'Host',
> 'url_queue.mail_cnt': 'Mail Count',
> 'url_queue.url': 'URL',
> 'url_queue.status': 'Status',
> },
> paginate=20,
> maxtextlength=100,
> searchable=True,
> deletable=True,
> editable=False,
> details=False,
> create=False,
> ui='web2py',
> )
>
>
>
>
> On Monday, June 4, 2012 12:40:49 AM UTC+8, Massimo Di Pierro wrote:
>>
>> Grid can do joins. Smartgrids cannot. The latter is "smart" in the sense
>> that it displays only one table at the time but knows how to link other
>> tables automatically.
>>
>> In principle it should be possible to make left joins work. Please open a
>> suggestion for improvement with an example on google issues
>>
>> Massimo
>>
>> On Sunday, 3 June 2012 11:21:44 UTC-5, weheh wrote:
>>>
>>> I'm running SQLFORM.smartgrid with a left= join as follows:
>>>
>>> grid = SQLFORM.smartgrid(
>>> db.url_queue,
>>> constraints=dict(url_queue=query),
>>> left=db.brand.on(
>>> (auth.accessible_query('read', db.brand, auth.user_id
>>> )) &
>>> (db.brand.id == db.url_queue.brand_id)
>>> ),
>>> fields=[...],
>>> headers={...},
>>> paginate=20,
>>> maxtextlength=100,
>>> searchable=True,
>>> deletable=True,
>>> editable=False,
>>> details=False,
>>> create=False,
>>> ui='web2py',
>>> linked_tables=[],
>>> )
>>> The left join is causing smartgrid to give me an "unsupported query"error
>>> message
>>> . If I comment out the left= arg, the error message goes away but the
>>> query returns the wrong data, as expected. Any help would be appreciated
>>> . Thanks.
>>>
>>
> On Monday, June 4, 2012 12:40:49 AM UTC+8, Massimo Di Pierro wrote:
>>
>> Grid can do joins. Smartgrids cannot. The latter is "smart" in the sense
>> that it displays only one table at the time but knows how to link other
>> tables automatically.
>>
>> In principle it should be possible to make left joins work. Please open a
>> suggestion for improvement with an example on google issues
>>
>> Massimo
>>
>> On Sunday, 3 June 2012 11:21:44 UTC-5, weheh wrote:
>>>
>>> I'm running SQLFORM.smartgrid with a left= join as follows:
>>>
>>> grid = SQLFORM.smartgrid(
>>> db.url_queue,
>>> constraints=dict(url_queue=query),
>>> left=db.brand.on(
>>> (auth.accessible_query('read', db.brand, auth.user_id
>>> )) &
>>> (db.brand.id == db.url_queue.brand_id)
>>> ),
>>> fields=[...],
>>> headers={...},
>>> paginate=20,
>>> maxtextlength=100,
>>> searchable=True,
>>> deletable=True,
>>> editable=False,
>>> details=False,
>>> create=False,
>>> ui='web2py',
>>> linked_tables=[],
>>> )
>>> The left join is causing smartgrid to give me an "unsupported query"error
>>> message
>>> . If I comment out the left= arg, the error message goes away but the
>>> query returns the wrong data, as expected. Any help would be appreciated
>>> . Thanks.
>>>
>>
