State Software Shortcut Reference Guide

%

Wildcard

=

value or .eq value will select all records equal to the value entered

>

value or .gt value will select all records greater than the value entered

>=

value  or .ge value will select all records greater than or equal to the value entered (default behavior for numeric fields)

<

value or .lt value will select all records less than the value entered  

<=

value or .le value will select all records less than or equal to the value entered

<>

value or .ne value will select all records not equal to the value entered

~

value or .like value will select all records starting with the value entered - ONLY WORKS FOR TEXT FIELDS; THIS IS THE DEFAULT BEHAVIOR FOR TEXT FIELDS IF NO OPERATOR IS ENTERED

*=

value1,value2,value3 etc. or .oneOf value1,value2,value3 etc. will select records containing one of the values listed - ONLY WORKS WITH NUMERIC FIELDS

value1..value2

value1..value2 or .between value1,value2 will select records between the values listed