Knowledge: Triggering Index of Item from SQL Data Action
Back
Knowledge
Title*Triggering Index of Item from SQL Data Action
ManualAdministration
Manual Level TwoData Actions
Manual Level ThreeSQL
Created28/10/2022
DetailIf you need to trigger an index of a claim from a SQL Data action, maybe after a SQL Update, then you can do the following in Data Action configuration:
- After any UPDATE, or appeneded to existing SELECT add a SELECT @ItemID as IndexItemID field. Note it does not need to be named IndexItemID. @ItemID is just an example, it can be whatever you have named it in Input Params, but obviously should be valid ID of Sysero Data Room Item.
- Add Additional Setting IndexColumn with value set to the name of the column you return for example @ItemID in the SELECT e.g. IndexItemID.
Additional Manual Locations