We need to amend Baloo schema to handle Moztrap specific data https://wiki.mozilla.org/Baloo/Schema/0.1 What fields should we add?
Here are the tables, fields, and related foreign key paths to get the info I think you'll need. email: auth_user.email result user: execution_result.created_by_id ==> auth_user result date: execution_result.created_on result to case: execution_result.runcaseversion_id ==> execution_runcaseversion case to run: execution_runcaseversion.run_id ==> execution_run run to product version: execution_run.productversion_id ==> core_productversion product version to product: core_productversion.product_id ==> core_product The result has a pretty long chain. But I think you can see how you can get information from each table in the chain. For instance: from execution_run, you can get the name of the test run, etc. But following it further down the foreign key chain, you can get to the core_product which would tell you if it's Firefox vs. Firefox OS, etc. Please ping me if you need more info on this.