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

[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-16 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 simil

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

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

[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) << > did you try using query ? > > e.g. > query=(db.project.created_by==auth.user) & (db.project.is_active==True) > grid=SQLFORM.gri

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

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

[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

[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

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