You are viewing limited content. For full access, please sign in.

Question

Question

Determining the number of times a specific stamp has been applied using Workflow

Workflow
Updated March 2, 2016
asked on March 1, 2016

I am creating a workflow which compiles our FOI statistics for our annual report to the Privacy Commissioner. One of the reporting items is the number of times we have redacted information for each of the exemption types. We indicate the reason for a redaction by applying a stamp indicating the exemption's section number. Through searches, I am able to determine how many documents contain a given stamp, but cannot figure out how to calculate the number of times the stamp has been applied. Is there a way to retrieve this information?
 

0 0

Replies

replied on March 2, 2016

You could probably accomplish this by querying the LF SQL db with a Query activity in your workflow.  Maybe something like this:

SELECT * FROM ann
INNER JOIN doc ON doc.page_id = ann.page_id
INNER JOIN toc ON toc.tocid = doc.tocid
WHERE ann.ann_type = 16
AND toc.tocid = [YourEntryID]

Where [YourEntryID] is the Entry_ID for your document.  Between the Toc, Doc, Ann and Stamp tables, all of the info you need should be there.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...