Requirement – Attachment – File Modified Date in a Report
Question ID: 108349

We have a project team that would like a report that lists the Requirement ID, Name, Attachment Name, and Attachment Modified date. It does not appear the Attachment Modified date is in the ALM database for any Project Report or EXCEL report. Is it? Or does ALM get the actual file modified date from the "file server" when one views the list of attachments for a Requirement. That appears to be the case and if so, how would one create a report with the Requirement ID, Name, Attachment Name, and Attachment Modified date? Thanks

Marked as spam
Posted by (Questions: 113, Answers: 8)
Asked on April 30, 2018 3:32 pm
Answers (1)
Private answer

The attachment SRLF_LAST_MODIFIED (Time of last file modification) is stored in the td.SMART_REPOSITORY_LOGICAL_FILE Table within the project.

The links between the entities and the files are maintained in the td.CROS_REF Table

CR_ENTITY - Holds the table of the entity the attachment is attached to

CR_KEY_1 - Holds the entity id (ex. requirement ID or Test ID)

CR_REFERENCE - Holds the filename

Marked as spam
Posted by (Questions: 0, Answers: 309)
Answered on April 30, 2018 3:33 pm
This is exactly what we needed! We have created the query with the file modified date now.
( at April 30, 2018 3:34 pm)

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

Scroll to Top