Didn't want to change the database structure as it would have been just wayy too much repetitive data. I did find a solution to my problem: First find the json_dir_ids that I want and make the grid's query be that, then use the grid's left join parameter. For instance, referring to my original post, I would query to get the json_dir id where json_dir.build=='unknown' and json_dir.program=='test'. Let's call that id MY_ID. Now my grid looks like this: block_grid = SQLFORM.grid(db.block_info.json_dir_id==MY_ID, left=[db.json_dir.on(db.json_dir.id==db.block_info.json_dir_id)], fields=[db.block_info.block_name, db.json_dir.program, db.json_dir.build], etc, etc, 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/groups/opt_out.
