...
- %value - will let you enter the last few digits of SSN or Number and will find that SSN. **Example: 123456789 to find 6789 type in %6789 and will pull just this one employee up in the grid**
- %value% - will let you enter a few digits of an SSN or Number and will find those SSN's with those numbers in it. **Example: 123456789 to fing 345 type in %345% and will show all employees with 345 in their SSN
- =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
- value1..value2 or .between value1,value2 will select records between the values listed
...