Query - Edit Properties Settings

Schedule Export

Setting Description
Limit Rows   Limit each query run to return the specified number of rows.
Execution Options
  • Retrieve all records each time the query is run: All records that meet the query criteria will be included in the query results each time the query runs.
  • Retrieve all records and save recent result history: All records that meet the query criteria will be included in the query results each time the query runs. Additionally, the history of the query results are saved for one year, so records that met the query criteria for previous query executions are visible.
  • Retrieve only the new records since the query was last run: When the query runs, only records that were not included in the previous query results will appear. The history of the query results are saved.
Fetch Behavior
  • Preserve where clause on fetch if required by one or more filters - If any of the filters in the query have the 'Preserve Where Clause' setting set to "Yes," the WHERE clause generated in the query is preserved each time the query results are retrieved. Most commonly used.
  • Always preserve where clause on fetch - Tells the query to always preserve the filters when viewing the query results, including viewing an individual run history. Records that may have initially met the criteria and were exported may no longer meet the criteria due to an update to the record made after the first run and therefore no longer show up in the run history. 

     

    There are only a few use cases to use the "Always preserve where clause on fetch" setting. Generally, the default option, "Preserve where clause on fetch if required by one or more filters," is used. You can find a slightly more technical overview of this function for tracking queries here.

Queue The Queue settings configure the query to retrieve records that were updated since the last run.
  • None (default) 
  • Application Update - Returns records with updated applications.
  • Person Update - Returns records where the person record has been updated.
  • Decision Update (Decisions query population only) - Returns records where decisions have been updated.
Primary Key and Secondary Key

The record GUIDs (globally unique identifier) are used in tracking queries to track which records are included in a query on a particular date and time. 

Was this article helpful?
0 out of 0 found this helpful