Exclude trash artifacts from BIRT report
Hello!
I developed a BIRT reports which can get a filtered list of test plans from Rational Quality Manager v4.0.7. But additionally, I see the artifacts from the Trash in that list. Is there a way filter those artifacts from the Trash and exclude them from the final report?
Thank you very much for any help or recommendations?
I developed a BIRT reports which can get a filtered list of test plans from Rational Quality Manager v4.0.7. But additionally, I see the artifacts from the Trash in that list. Is there a way filter those artifacts from the Trash and exclude them from the final report?
Thank you very much for any help or recommendations?
One answer
Hi Dmitry
If you are using the RQM Reportable REST API for your report, you can use the ?includeArchived=false parameter. That should filter out the artifacts in the trash. See https://jazz.net/wiki/bin/view/Main/RqmApi#includeArchivedhttps://jazz.net/wiki/bin/view/Main/RqmApi
Toni
Comments
Hi Toni,
Thank you for the recommendation but we don't use REST API in the BIRT report for RQM. But we found another tricky way, may be it can be useful for somebody.
There are two tables with their own advantages and shortages:
1. com.ibm.rqm.planning.TestPlan - many data about test plans but it includes the ones from trash
2. com.ibm.rqm.planning.VersionedTestPlan - minimum data about test plans but it contains all snapshots and doesn't include plans from trash
We linked the plans 1 & 2 by inner join for test plans IDs. Additionally we excluded snapshot plans from 2 by "snapshot = false" filter. At the end we have got the active plans only!