Exclude trash artifacts from BIRT report

Dmitry A. Lesin (246●2●50●94) | asked Oct 20 '15, 6:01 a.m.

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?

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Antoinette Iacobo (650●7●12) | answered Oct 23 '15, 10:44 a.m.

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

Dmitry A. Lesin commented Oct 28 '15, 1:39 p.m.

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!

It's all about the answers!

Related questions

Exclude trash artifacts from BIRT report

One answer

Your answer