It's all about the answers!

Ask a question

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

Daniel Chirillo (1801723) | asked Nov 27 '15, 11:28 a.m.
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?

Accepted answer

permanent link
Joao Carusi (263214) | answered Dec 04 '15, 12:13 p.m.
edited Dec 04 '15, 12:26 p.m.
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/"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

Your answer

Register or 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.