KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

Description:

Keeps all Records in the WorkQuery that include all SearchTerms in the specified Fields. If Fields is blank or not specified, all Fields are searched.

If an entire Database Table is to be search, this command will perform slower than the Search command which is intended to search an entire table. However, this command is very useful for searching within a subset of pre-filtered data, or searching across Relationships.

Usage:

KeepIfFound FieldBase, Fields, SearchTerms
KeepIfFound [WorkWith], Fields, SearchTerms
KeepIfFound [""], [""], SearchTerms