Knowledge: Re-indexing SQL data action results
Back
    Title*Re-indexing SQL data action results
    ManualAdministration
    Manual Level TwoData Actions
    Created30/11/2023
    Detail

    After 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. 
    Privacy Policy
    Cookies help us to improve your user experience. By using this site you consent to cookies being stored on your device. Read more...
    Back to Top
    View or hide all system messages