Good day, We're using web2py and loving it, but we ran into an issue with the sqlform.grid. Quick sketch of my situation:
A relatively complex query is build up according to filter settings. This recently included joins to other tables and not just one to many, but many-to-many. Ie there is a table containing items and a table containing groups and a table that links these two together, let's call it 'group_item'. You can imagine I want to show only items belonging to a certain group(s) - if that particular filter is activated. It works, meaning they show up in the grid overview, but the links to the 'view' and 'edit' pages are now defunct (they refer to the linking table 'group_item' instead of 'item'). The result of the query is a nested set, items, groups and group_items, so the grid doesn't know which one I actually want to view/edit. I can think of quite some ways to fix this in an ugly way (build view/edit links myself or even worse I could change them after loading with JS ;) ) I was hoping there is some known way of dealing with this situation (having a query that gives a nested result), perhaps the grid can somehow be informed it should only use the 'item' results? Thanks! -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
