Report Builder - Table/Schema Information
This question is about JRS report builder.We are trying to pull data about custom reports created through report builder like when was it created and who created like that information etc. Can you be able to tell me what are Table and Schema Names, whether they live in JTS/CCM/RS database?Any help on this highly appreciated..
2 answers
Hi Deepthi,
Let me clarify, would you like to create a report of Report Builder report templates (eg. when the report was created, who created a report... )? The Report Builder report definition is stored in [JazzTeamServer]\server\conf\rs\db as a Jena TDB. So there is no concept of relational database (table/schema), but RDF format. As long as I know, there is no documentation how RDF is defined for Report Builder, so you may need to find it by yourself by using tdbdump etc.. (I have never done it before though)
https://jena.apache.org/documentation/tdb/commands.html
Alternatively, you may always add a tag in the report template in Report Builder such as creation date, and filter by tag. This is much easier approach.
Hi Kenji Sarai,
Comments
If you cannot find the folder location what I mentioned earlier, perhaps it has been relocated explicitly. Open [CLM Install]\server\conf\rs\app.properties in a text editor, and check DBLocation parameter such as DBLocation=E\:/RS/DB. This is what you are after.
Please note that the Jena TDB data is not human readable, so you need to convert it somehow like tdbdump. Ensure to back up your data, just in case.