HP ALM: How to Export All Attachments With Test References in a Project
Question ID: 108096
0
0

We are looking to export all of the attachments from a particular project and still be able to reference the tests related to the attachment so that we can cross-reference the attachment on a report. Is this possible?

Marked as spam
Posted by (Questions: 204, Answers: 2)
Asked on January 25, 2018 10:08 pm
1281 views
Answers (1)
0
Private answer

GoDawgs,

Here is a query to find out which test cases had attachments:

SELECT * FROM SMART_REPOSITORY_LOGICAL_FILE
WHERE SRLF_PARENT_PATH = '.attach' AND
SRLF_NAME LIKE '%TEST%' OR
SRLF_NAME LIKE '%STEP%'

This will give you all attachments. If you only want attachments to Tests, take off the final OR clause but this would remove any attachments to Test Steps.
Unfortunately, this query is on the Smart Repository Logical File and not the Physical File so you may need help from your DBA to get to your physical files. I do think that the test IDs are listed in the resulting SRLF_NAME field as TEST_*_FileName.

Marked as spam
Posted by (Questions: 1, Answers: 216)
Answered on January 25, 2018 10:12 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top