Sometimes the results from a search need to be refreshed because the underlying data has changed, for example, the audit status has been updated. This could be achieved by re-running the search, but this would be unnecessarily time consuming. Instead, there is a mechanism to run a mini search to retrieve just the updated information, and merge this into the results already in the results cache. This is enabled using the update="true" attribute on the <results> element.
The mini search stored procedure has the same name as the main search, but prefixed with 'Update_' for example, for the standard search, the main SP name is Standard_Search_V2_1; the update mini SP is called Update_Standard_Search_V2_1. The stored procedure takes a single parameter, which is a string containing a comma-separated list of values. These are key values obtained from the column identified by the ref attribute of the <results> element, for every selected row of the results. The ref attribute must refer to a column defined as a primary key i.e. the corresponding column must have the attribute primary_key="true".
The names of the columns in the result-set from the mini search must correspond to those in the original results (although not all columns need to be defined). The primary key column is used to identify records in the original results, and columns with matching names are replaced by values from the mini search results.
|
Copyright © 2014 CA.
All rights reserved.
|
|