2 Replies Latest reply on Nov 26, 2012 5:50 PM by RG1000

    Reporting / extraction for open signature documents

      I am trying to report out on the open signature documents by user and functional area. I am finding this to be a challenging extraction from the database because many of the signature documents shown as "review" status in the gsmSignatureDocs table are old or no longer relevent to the current spec level workflow step. For example, if someone had a signature document in a "spec review" stage but the owner workflowed it back to draft before the signature doc was actioned then workflowed back to a "spec review" stage, the orginal unactioned signature document remains and will remain unactioned. I am only interested in open signature documents in the current review stage of the spec. Any way to pull this data to compile the output I am looking for?

      For NPD signature docs, it appears I may be able to leverage the "is voided" field but would need your confirmation if all unactioned items get voided if the activity is workflowed back prior to completion of a signature document. If not, would need a way to do this as well.

      Using agile 5.2 DB schema...