Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to Get ID of Attachment Added to RQM Test Case Result

I'm working with a customer that is developing scripts using NI TestStand and executing them from RQM using the NI RQM adapter.  The challenge is getting the TestStand report that is attached to the RQM Test Case Results printable.   QM's built-in print to pdf capability doesn't include it, so we'll need to use other means.  

To get it at it ourselves, we need to get the report attachment that the adapter added to the test case result. The challenge is that:

1.  The TestStand report is an attachment. It's visible in the QM attachment feed:

QM Attachment Feed

2.  Unfortunately the executionresult doesn't include the ID (32 above) of the attachment.  It only includes what appears to be a slug ID:



The question is thus:  how can I get use the slug in the executionresult to get the attachment?

0 votes


Accepted answer

Permanent link
Option 1: Run a database query to resolve the ID of the attachment. The query to run is:

select ID from planning.attachment where item_id= "value of reportpdf element in the RQM Test Case Result"

This enables one to construct the 'normal' REST URL of the attachment and to make it gettable by RPE


Option 2: Request the attachment using the internal (non-public) URL:

https://QMSERVER/qm/service/com.ibm.rqm.planning.service.internal.rest.IAttachmentRestService/"value of reportpdf element in the RQM Test Case Result"

This option could be used by custom code only (RPE can only use the normal public REST URLs)
Daniel Chirillo selected this answer as the correct answer

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,950
× 481

Question asked: Nov 27 '15, 11:28 a.m.

Question was seen: 3,244 times

Last updated: Dec 04 '15, 12:26 p.m.

Confirmation Cancel Confirm