Page 1 of 1

Set Metadata To SQL Result

Posted: Fri Feb 09, 2018 3:44 pm
by DHemken
I have Job numbers being stored in a database. However, sometimes multiple files for the same job are submitted at different times. I have an Identity column in my sql table so i can track which files are for which entry. I need a way to Store that number in the File's metadata.

Re: Set Metadata To SQL Result

Posted: Wed Feb 14, 2018 4:29 pm
by Padawan
There are different ways to store data in Switch metadata, then there are a few variables you can store it in:
- JobState
You can do this by setting the "attach job state" property in a folder to your database variable
- Job priority
You can do this by setting the "set job priority" property in a folder to your database variable
- Private data
You need a script or an App (https://www.enfocus.com/en/appstore/product/metatagger) to set private data.

All of these values can be retrieved via Switch variables