Requirement – Attachment – File Modified Date in a Report
| ♥ 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 |
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 jefptman (Questions: 0, Answers: 309) Answered on April 30, 2018 3:33 pm
|