Update Data Source
I would use a Document Task when it succeeds and that task would be either Run Script or Run SQL Command. If it's a SQL table, then using Run SQL Command would be the better option in my opinion.
If I run a script that says "update [table] set integrated = 1', is that going to update ALL records in [table] or just the doc that was just successfully integrated before I ran this Document task/success? Or do I need to qualify WHICH record it needs to update? If I need to qualify with a where clause, how do I tell it what doc just ran?
You would need to specify the document restriction in a where clause.
Select a SQL Task in the Document Succeed Event
Get the Source document by click on the Insert Variable button.
Your SQL Statement would be something like
update [table] set integrated = 1 WHERE document = '_Document'
if your document is a string you must include the single quote. Smart Connect will replace the variable name with the actual value when the task executes.
Hope that helps
If you would like to submit an answer or comment, please sign in to the eOne portal.