In one of our projects we have to synchronize access to documents based on information we pull from a SQL database. It is a simple table with only one column for CaseID field which corresponds to Case # field assigned to each document. There may be many documents for any given CaseID and we have to search for all of them to apply a corresponding security tag. All secure tags are already created and are the same as CaseID numbers.
The workflow we have already does most of what we need (see attachment);
1. Execute Custom Query - this gets us all CaseIDs
2. For Each Row we:
2.1 Assign a token DB_CASE_ID to equal to CaseID
2.2 Search repository for all documents that have a Case # field equal to CaseID ({[]:[Case #]=%(ForEachRow_CASEID)})
2.2.1 For Each Entry, for each found entry execute a SDK script to assign a security tag
The workflow works and the only thing we have missing is the SDK script to assign corresponding security tags.
We use workflow version 10.2.1.113
Any help on the SDK script would be much appreciated.
Thanks.