Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.51

Develop > Programming Guide > System Language reference > List: RAD functions > RAD function: evaluate.query

RAD function: evaluate.query

A RAD function that evaluates a query against a record. Both are passed as function parameters.

Function

evaluate.query()

Format

$L.rc=evaluate.query( <query>, <file variable> )

Function returns

true: if the record matches the query.

false: if it does not match the query.

unkown: if a comparison in the query encountered a NULL value or a field was referenced in the query that does not exist in the record.

null: if the function was called incorrectly.

Parameters

The following parameters are valid for the evaluate.query function:

Parameter	Data type	Description
query"<query>"	operator or character	Can be a previously parsed query or a string containing a query
record"<file variable>"	record	Must be a valid file variable

Examples

$x = evaluate.query( "true", $L.file )

This example returns TRUE for any valid file variable.

$query = parse( "contact.name # \"S\" ", 4 )
$y = evaluate.query( $query, $L.filed )

This example returns TRUE only for contacts records that start with "S" and FALSE for every other contacts record.