Inflectra Customer Forums: Writing a Report to Show the Electronic Signatures in SpiraTeam (Thread) In SpiraTeam v5.0 we added native support for electronic / digital signatures . This was to allow our customers in regulated industries such as healthcare and finance be able to ensure that workflow changes were only performed by the appropriate personnel and that there was a signed audit trail of the change. A customer asked us how to write a custom report to display the electronic signatures in a project. en-US(C) Copyright 2006-2024 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/1786.aspxthreadId=1786David J (support1@inflectra.com)custom report electronic signatures digital signaturesWriting a Report to Show the Electronic Signatures in SpiraTeam In SpiraTeam v5.0 we added native support for electronic / digital signatures . This was to allow our customers in regulated industries such as healthcare and finance be able to ensure that workflow changes were only performed by the appropriate personnel and that there was a signed audit trail of the change. A customer asked us how to write a custom report to display the electronic signatures in a project. Fri, 15 Dec 2017 21:40:02 -05002017-12-15T21:50:50-05:00/Support/Forum/spirateam/reports/1786.aspxmessageId=3193David J (support1@inflectra.com) The following Entity SQL (ESQL) query can be used to display such reports: select H.CHANGESET_I The following Entity SQL (ESQL) query can be used to display such reports: select H.CHANGESET_ID, H.ARTIFACT_TYPE_NAME, H.ARTIFACT_ID, H.ARTIFACT_DESC, H.CHANGETYPE_NAME, H.USER_NAME, H.SIGNATURE_HASH, C.COMMENT_TEXT as MEANING from SpiraTestEntities.R_HistoryChangeSets as H join SpiraTestEntities.R_Comments as C on C.CREATION_DATE = H.CHANGE_DATE and H.ARTIFACT_ID = C.ARTIFACT_ID and H.ARTIFACT_TYPE_ID = C.ARTIFACT_TYPE_ID and H.SIGNATURE_HASH is not null You enter that in the Query section, then click the Create Default Template and click Save. Fri, 15 Dec 2017 21:41:02 -05002017-12-15T21:41:02-05:00/Support/Forum/spirateam/reports/1786.aspx#reply3193messageId=3194David J (support1@inflectra.com) If you want to also include the date on the report, please use this modified version: select H.CH If you want to also include the date on the report, please use this modified version: select H.CHANGESET_ID, H.ARTIFACT_TYPE_NAME, H.ARTIFACT_ID, H.ARTIFACT_DESC, H.CHANGETYPE_NAME, H.USER_NAME, H.SIGNATURE_HASH, C.COMMENT_TEXT as MEANING, H.CHANGE_DATE from SpiraTestEntities.R_HistoryChangeSets as H join SpiraTestEntities.R_Comments as C on C.CREATION_DATE = H.CHANGE_DATE and H.ARTIFACT_ID = C.ARTIFACT_ID and H.ARTIFACT_TYPE_ID = C.ARTIFACT_TYPE_ID and H.SIGNATURE_HASH is not null To format the XML date as something more readable, you could use the following XSLT template: CHANGESET_ID ARTIFACT_TYPE_NAME ARTIFACT_ID ARTIFACT_DESC CHANGETYPE_NAME USER_NAME SIGNATURE_HASH MEANING CHANGE_DATE Fri, 15 Dec 2017 21:50:50 -05002017-12-15T21:50:50-05:00/Support/Forum/spirateam/reports/1786.aspx#reply3194