We have a process where an active document is moved to a processing folder. Whilst in this processing folder, a new metadata template is applied with new metadata values. Once that is completed, the file is manually moved to a Records Management folder until it is disposed.
However, upon a rare occasion, a request will come through to restore the file to active again.
What I am trying to figure out is, how can I restore its original metadata template and values? I can create a workflow that stores the template name and values. This is based on the laserfiche database tables, toc, propval, propdef, propset and pset_props. I just can't work out how to set the template and values in workflow without creating a decision for each template etc.
I know that I am probably not explaining this too well. Any help would be appreciated