Search Operands

There are three main operands used for searching: ‘equals', ‘contains’, and ‘is like’.

The ‘equals’ operand is used for fields that have fixed values, such as those utilizing a drop-down. Other fields such as date fields may also use a ‘greater than' or 'less than’ operand if exact dates are not known.

The ‘contains’ operand allows results with multiple words or hyphenated words to be retrieved without having to know what the first word is. I.E., the last name Smith-Johnson could be retrieved by either searching for Smith OR Johnson. The ‘contains’ operand DOES NOT retrieve results based on partial words.

If we instead use the ‘is like’ operand, we can retrieve by any number of partial words, so long as we are searching for the beginning of that word. I.E., searches for ‘smi’, ‘Jo’, or ‘SM’ would return Smith-Johnson, but ‘ith’, ‘ohn’, or ‘son’ would not.