Database Connection for SmartConnect Task
I have the need to run a task after each document succeeds. The task is a Run SQL Command task which needs to run against the specific database applicable to the record that succeeded.
Is this possible? If so, what is the syntax of the SQL update query.
- The DATEADD function returns the current date and time from the computer and replaces the time portion with all zeros
- _BATCHID refers to a field in the data source
Great work Darren – really appreciate you sharing the answer with everyone.
How did you get the field value into the GlobalFileName?
He would have used a calculation at some point, or a Restriction script, or “before or after” document script.
GlobalFileName = _COMPANYID (the source field)
then when he ran the SQL, the value would be populated.
If you would like to submit an answer or comment, please sign in to the eOne portal.