Knowledge: Re-indexing SQL data action results
Back
Knowledge
Title*Re-indexing SQL data action results
ManualAdministration
Manual Level TwoData Actions
Created30/11/2023
DetailAfter a SQL data action is run, you may wish to force the results to re-index. We have two options available for this:
- Make sure that the results set returns a column with the Claims.ID as "SyseroIndexItemID". This will iterate over the SQL results row by row and re-index each one individually. This is not asynchronous and so is only recommended for use when the results set will be quite small.
- Make sure that the results set returns a column with the Claims.ID as "SyseroIndexQueueItemID". This will add the results in bulk to the index queue for processing either as part of a larger manual re-index operation or as part of a scheduled timer service job. This is recommended for larger data sets but please note it will incur a delay due to needing to wait for any timer service index queue jobs to run. This will also not run automatically without a timer service re-index job configured to process the index queue.
Additional Manual Locations