Tokens

Tokens can be included in the SQL query. What happens when you execute the search in the Search <object> page?

• The tokens that are in the format of [%%DETAIL.FIELDNAME] are compared to the names of the Simple search fields.
• The matching tokens are replaced with the actual field names.
• Any criteria that is specified in the Search <object> page that does not match the SQL query is ignored.

Standard token replacement, such as [%LAB] and [%USER] are also supported by the DIY query.

Creating queries for use in the Search <object> pages is ideal. The Optiva administrators can maintain control of the SQL code that is executed in the search. Users can reuse the SQL code for subsequent searches.