[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-05-01 Thread Cliff Kachinske
you could use links something like def get_stuff(user_id): # fetch the items for that user # iterate through items, intersperse with BR() # return the whole mess in a SPAN() # Caveat: not sure of following syntax and too lazy to look it up in manual # Just look in the writeup for

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-04-30 Thread Alex Glaros
Am returning to this question as I have a better description of what I'm looking for. The example is the owner's list of all shopping purchases in a store for one day. George - 10 coffee cups 1 blender 3 boxes of laundry soap Henry -2 napkin holder Customer

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-17 Thread Alex Glaros
thanks Steve but your example doesn't have the child detail records the way mine does, so it's a different example pythonanywhere host seems great I'll hold off on this problem till later much appreciated, Alex On Saturday, March 16, 2013 5:39:58 AM UTC-7, 黄祥 wrote: maybe my code is

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-16 Thread Alex Glaros
Thanks Jason, but it only made the parent ID completely disappear from the child file, not keep the first instance of parent ID as desired I think I'm asking too much from smartgrid Alex On Wednesday, March 13, 2013 3:02:44 PM UTC-7, Jeison Dück wrote: Putting this, on controller -

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-16 Thread Alex Glaros
Hi Jason, my real fields are so different, I need a little help. Can you please tell me what does what so I can implement? E.g. (db.project.created_by==auth.user) selects the current user's data only?? db.project.is_active==True) only selects data not archived?? etc. which part makes parent ID

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-16 Thread 黄祥
query=(db.project.created_by==auth.user) (db.project.is_active==True) is the query that check wheter the database table project is created by the current authenticate user *AND *the database table status is active i think if you want to show the database table project is created by the

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-16 Thread 黄祥
maybe my code is similar for you, please check : https://sugizo.pythonanywhere.com/task/default/task email : us...@gmail.com password : password email : us...@gmail.com password : password if you want i can share the code. in that webapps, i'm using task, maybe you can change it into database

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-15 Thread 黄祥
did you try using query ? e.g. query=(db.project.created_by==auth.user) (db.project.is_active==True) grid=SQLFORM.grid(query, user_signature=False, onupdate=auth.archive) -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-13 Thread Niphlod
you mean in the exported file ? On Wednesday, March 13, 2013 7:21:18 AM UTC+1, Alex Glaros wrote: In smartgrid, is there a way to keep the parent ID from repeating in the child file? I'd like for the parent ID field to appear only once in the child file at the beginning where the first

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-13 Thread Alex Glaros
not the export file, I meant to suppress its display to the user like: John's projects - feed the dog - water the garden - mow the lawn Sues' projects - vacuum the house - wash the dishes right now it comes out like this John's projects feed the dog John's projects water

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-13 Thread Niphlod
Sorry, I don't see any easy way to do it natively: the table you see in a smartgrid is a resultset from a join, and rdbms don't group natively in an analytic fashion the resultset. you can try with javascript, though. On Wednesday, March 13, 2013 4:31:01 PM UTC+1, Alex Glaros wrote: not the

[web2py] Re: smartgrid: how to disable repeating parent ID in child record

2013-03-13 Thread Jeison Dück
Putting this, on controller - db.project_table.description.readable = False - before loading the Smartgrid component, does not work? It worked for me. Regards Jason On Wednesday, March 13, 2013 3:21:18 AM UTC-3, Alex Glaros wrote: In smartgrid, is there a way to keep the parent ID from