You should perform an ajax request to pass model (id or name) to the controller that would perform corresponding query like db((db.stock.id == db.products.stock) & (db.products.model==request.args(0)) ).select(db.products.ALL) and return it back You can use the same controller to do it with this simple logic: if not request.args(0): # url is .../table_stock <return group-by-list> else: # url is .../table_stock/some_model <return product-list-by-some_model>
and, of course, you have to write some js-code On Monday, June 18, 2018 at 4:44:13 PM UTC+3, Ayron Rangel wrote: > > Massime, > > I would like it to show on the "modal" the list of all models products > equal to the table row. Ex.: > I have in my first row of the table all products with the model A (in > query i'm using group by = 'db(query).select(db.products.ALL, > db.stock.ALL,count,somar, groupby=db.products.model')). So appears just the > product model name. > > In the same row, when i click in the icon, i want to list all products > with the same "group by model". > > Did u get it? > -- 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.