TSMapp Help

>

Greater Than

>=

Greater Than or Equal

=

Equal

<=

Less Than or Equal

<

Less Than

<>

Not Equal

LIST

LIST - Comma Separated String containing possible search strings. One or more search strings MUST be found

NOT LIST

NOT LIST - Comma Separated String containing possible search strings. Results must NOT contain search strings.

BETWEEN

BETWEEN - Between (Number is between 2 Comma Separated Values). This is the same as Greater Than or Equal combined with Less Than or Equal.

LIKE

Exact Match

*LIKE*

Wild-card either end of string.

*LIKE

Wild-card at the beginning of the string.

LIKE*

Wild-card at the end of the string.

NOT LIKE

Must NOT be an exact match.

*NOT LIKE*

Must NOT be an exact match with wild-cards.

IS EMPTY

Value being searched is blank.

Deprecated

IS NOT EMPTY

Value being searched can NOT be blank.

Deprecated

LIST

Comma Separated String containing possible search strings. One or more search strings MUST be found.

NOT LIST

Comma Separated String containing possible search strings. Results must NOT contain one or more of the search strings.

*LIST*

Comma Separated String containing possible search strings. One or more search strings MUST be found. Note this allows wild-cards either end of the string.

*NOT LIST*

Comma Separated String containing possible search strings. Results must NOT contain one or more of the search strings. Note this allows wild-cards either end of the string.

*LIST*(AND)

Comma Separated String containing possible search strings. All the search strings MUST be found. Note this allows wild-cards either end of the string.

*NOT LIST*(AND)

Comma Separated String containing possible search strings. Results must NOT contain any  of the search strings. Note this allows wild-cards either end of the string.