...
You can also filter using any of the following. For example, typing in "=1000" will find all records where the value in that column equals 1000. Similarly, typing in ".eq 1000" would also find the same results.
- % 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 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
...