Set Metadata To SQL Result

Post Reply
DHemken
Newbie
Posts: 2
Joined: Wed Dec 13, 2017 8:16 pm

Set Metadata To SQL Result

Post 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.
Padawan
Advanced member
Posts: 358
Joined: Mon Jun 12, 2017 8:48 pm
Location: Belgium
Contact:

Re: Set Metadata To SQL Result

Post 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
Post Reply