Those of us who work in safety-critical industries are sometimes asked to generate history report for Documents, with its approvals, comments, audit trail and so on. I know that Spira isnt really a DMS (or, god forbid, a QMS) but if it can do it, then why not? The following report will generate detailed document history report with versions, authors, comments, change history and so on. ESQL SELECT DOC.ATTACHMENT_ID, DOC.FILENAME AS DOCUMENT_NAME, DOC.DESCRIPTION, DOC.DOCUMENT_STATUS_NAME AS STATUS, DOC.DOCUMENT_TYPE_NAME AS TYPE, DOC.AUTHOR_NAME, DOC.EDITOR_NAME, DOC.CURRENT_VERSION, DOC.UPLOAD_DATE, DOC.EDITED_DATE, DOC.PROJECT_ATTACHMENT_FOLDER_NAME AS FOLDER, HIST.CHANGESET_ID, HIST.USER_NAME AS CHANGED_BY, HIST.CHANGE_DATE, DET.FIELD_CAPTION, DET.OLD_VALUE, DET.NEW_VALUE, CMT.CREATOR_NAME AS COMMENT_AUTHOR, CMT.CREATION_DATE AS COMMENT_DATE, CMT.COMMENT_TEXT FROM SpiraTestEntities.R_Attachments AS DOC LEFT JOIN SpiraTestEntities.R_HistoryChangeSets AS HIST ON DOC.ATTACHMENT_ID = HIST.ARTIFACT_ID AND HIST.ARTIFACT_TYPE_ID = 13 AND HIST.PROJECT_ID = ${ProjectId} LEFT JOIN SpiraTestEntities.R_HistoryDetails AS DET ON HIST.CHANGESET_ID = DET.CHANGESET_ID LEFT JOIN SpiraTestEntities.R_Comments AS CMT ON DOC.ATTACHMENT_ID = CMT.ARTIFACT_ID AND CMT.ARTIFACT_TYPE_ID = 13 WHERE DOC.PROJECT_ID = ${ProjectId} XSLT Field Value Version Status Author Last Editor Creation Date Last Modified Folder Type Description Change History No change history recorded. Date Changed By Field Old Value New Value Comments No comments recorded. Date Author Comment Let me know if youve found any issues with it! en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/3189.aspxthreadId=3189Vladimir Plotkin (vladimir@inmarsys.com) Those of us who work in safety-critical industries are sometimes asked to generate history report for Documents, with its approvals, comments, audit trail and so on. I know that Spira isnt really a DMS (or, god forbid, a QMS) but if it can do it, then why not? The following report will generate detailed document history report with versions, authors, comments, change history and so on. ESQL SELECT DOC.ATTACHMENT_ID, DOC.FILENAME AS DOCUMENT_NAME, DOC.DESCRIPTION, DOC.DOCUMENT_STATUS_NAME AS STATUS, DOC.DOCUMENT_TYPE_NAME AS TYPE, DOC.AUTHOR_NAME, DOC.EDITOR_NAME, DOC.CURRENT_VERSION, DOC.UPLOAD_DATE, DOC.EDITED_DATE, DOC.PROJECT_ATTACHMENT_FOLDER_NAME AS FOLDER, HIST.CHANGESET_ID, HIST.USER_NAME AS CHANGED_BY, HIST.CHANGE_DATE, DET.FIELD_CAPTION, DET.OLD_VALUE, DET.NEW_VALUE, CMT.CREATOR_NAME AS COMMENT_AUTHOR, CMT.CREATION_DATE AS COMMENT_DATE, CMT.COMMENT_TEXT FROM SpiraTestEntities.R_Attachments AS DOC LEFT JOIN SpiraTestEntities.R_HistoryChangeSets AS HIST ON DOC.ATTACHMENT_ID = HIST.ARTIFACT_ID AND HIST.ARTIFACT_TYPE_ID = 13 AND HIST.PROJECT_ID = ${ProjectId} LEFT JOIN SpiraTestEntities.R_HistoryDetails AS DET ON HIST.CHANGESET_ID = DET.CHANGESET_ID LEFT JOIN SpiraTestEntities.R_Comments AS CMT ON DOC.ATTACHMENT_ID = CMT.ARTIFACT_ID AND CMT.ARTIFACT_TYPE_ID = 13 WHERE DOC.PROJECT_ID = ${ProjectId} XSLT Field Value Version Status Author Last Editor Creation Date Last Modified Folder Type Description Change History No change history recorded. Date Changed By Field Old Value New Value Comments No comments recorded. Date Author Comment Let me know if youve found any issues with it! Thu, 30 Apr 2026 09:44:50 -04002026-04-30T09:44:50-04:00/Support/Forum/spirateam/reports/3189.aspx