How to edit Advanced Query Section in JRS for creating reports with Custom Fields.
Hi All,
We have a requirement in which we need to customize the ready to copy reports in Jazz Reporting Service (JRS) , which is possible in the tool provided we edit the Advanced Query section in the reporting tool . For achieving the same , we need information about the physical table names and the name of fields in the Database Schema at the back-end.
Kindly throw some light on the same, how to get the Database schema/ Database Model which can facilitate us to create customized reports as we need reports based on Custom fields.
2 answers
Hi Lissy,
It is not possible to duplicate or edit the Ready to Use reports so that you can see the Advanced Query. There may be other alternatives, depending on the kinds of reports you need. We have published a set of reports outside the box that are editable and can be copied/duplicated and you can see all of the Advanced SQL. Those reports are here: https://jazz.net/library/article/93757.
An easy way to start to learn about the database schema for crafting your own SQL is to create a "dummy" report that includes the artifacts, traceability, conditions and columns that you want and then look at the SQL to see how that report generates the result set.
I hope this helps.
Amy Silberbauer
(asilber@us.ibm.com)