I thin it's not necessary adding rows id's, almost for me it don't change nothing.
Yes like that it's searchable and you can order rows, but in the details view you've the db.l1_categories.id and the db.l1_categories.name. In your case for example 1 and "Music". Il giorno giovedì 22 gennaio 2015 11:48:58 UTC+1, Alex Glaros ha scritto: > > with your new join, the fields are searchable, this search works on my > version: > > l2_categories.name = "Jazz" > > l1_categories.name = "Music" > > Maybe fields need to be explicitly identified in grid command: > > grid = SQLFORM.grid(query, fields = [db.l1_categories.name, db. > l1_categories.id, db.l2_categories.name, db.l2_categories.id]) > > They don't have to be displayed, but have to be there in the background in > order to sort, etc. > -- 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.
