We were all there once. Glad I was able to help. Part of the beauty of
web2py is the community and the friendly help you can get on this group.
-Jim
On Wednesday, July 19, 2017 at 9:26:08 AM UTC-5, Matthew J Watts wrote:
>
> Great thanks Jim, that did it for me - it's hard being a beginner!!
>
> On Wed, Jul 19, 2017 at 2:09 PM, Jim S <ato....@gmail.com <javascript:>>
> wrote:
>
>> I'd start first with changing this:
>>
>> links = [lambda ids: A('Download data
>> set',_href=URL("default","download_dataset.csv",args=[ids.id]))]
>>
>> to this:
>>
>> links = [lambda ids: A('Download data
>> set',_href=URL("default","download_dataset.csv",args=[ids.MAIN.id
>> <http://ids.id/>]))]
>>
>> When you add the LEFT join you then need to specify which table to get
>> the field from.
>>
>> -Jim
>>
>>
>> On Wednesday, July 19, 2017 at 6:44:45 AM UTC-5, Matthew J Watts wrote:
>>>
>>> Hi all
>>>
>>> I'm having some problems trying to achieve the following
>>>
>>> I have a grid with left joins which selects a subset of entries in my
>>> database -(query between 3 tables)
>>>
>>> i then want to be able to set up links within the grid that sends the
>>> id from each row (MAIN table) to a seperate function (another query between
>>> many tables).
>>>
>>> I then want to trigger a download 'csv' file.
>>>
>>> So far, I have managed to get this working if I use one table in the
>>> grid (no left joins), however when i set up left joins within the grid,i
>>> get an 'AttributeError' message. Somehow, by setting up the left joins,
>>> i loose the main id that i want to send to the seperate function -
>>> although i have set up 'field_id=db.MAIN.id <http://db.main.id/>' in
>>> the grid
>>>
>>> Here's the code:
>>>
>>> *Controller*
>>>
>>> def vec_dyn_query():
>>> links = [lambda ids: A('Download data
>>> set',_href=URL("default","download_dataset.csv",args=[ids.id]))]
>>> grid = SQLFORM.grid((db.MAIN),
>>> field_id=db.MAIN.id,
>>> left = [db.StudyLocation.on(db.MAIN.LocationID
>>> == db.StudyLocation.id), db.TAXON.on(db.MAIN.TaxonID == db.TAXON.id)],
>>> links=links,
>>> deletable=False, editable=False, details=False,
>>> selectable=False, create=False, csv=False)
>>> return locals()
>>>
>>> def download_dataset():
>>> main_id = request.args(0,cast=int)
>>> dataset = db(db.MAIN.id == request.args[0]).select()
>>> return dict(dataset=dataset)
>>>
>>> *Views*
>>>
>>> {{
>>> import cStringIO
>>> stream = cStringIO.StringIO()
>>> dataset.export_to_csv_file(stream)
>>> response.headers['Content-Type'] = 'text/csv'
>>> response.write(stream.getvalue(), escape=False)
>>> }}
>>>
>>> Note - if i take away the 'left =
>>> [db.StudyLocation.on(db.MAIN.LocationID == db.StudyLocation.id),
>>> db.TAXON.on(db.MAIN.TaxonID == db.TAXON.id)],' Everything works fine
>>>
>>> Thanks for your help in advance
>>>
>>> Matt
>>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/pH_iiWr43UI/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
