...

• %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 ~value or .like value will select all records starting with the value entered (only works for text fields; . Example: ~8  will find all 800-899 codes in your search 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 ~value - Example: ~8  will find all 800-899 codes in your searchlisted

Sort

Users can sort any column by ascending or descending order by simply clicking on the column header name. To sort by more than one column at a time the user would click on the column header name they wish to sort by first and then hold down the shift key and click on another column header name. The columns are noted with a number beside the column name to show the order it was sorted. The sort can be reset by clicking on any column header name.

...