Requirement – Attachment – File Modified Date in a Report

  • Questions
  • Requirement - Attachment - File Modified Date in a Report
Question ID: 108349
0
0

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: 104, Answers: 7)
Asked on April 30, 2018 3:32 pm
9 views
Answers (1)
0
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.

https://admhelp.microfocus.com/alm/en/12.53/api_refs/project_db/topic528.html

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

https://admhelp.microfocus.com/alm/en/12.53/api_refs/project_db/topic199.html

Marked as spam
Posted by (Questions: 0, Answers: 298)
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)