...

• %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. 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

  listed                                                                                                                               

To filter on more than one grid option click on the first option on the grid you would like to filter on.  To add another filtering option hold the Shift key and click on the next field option you wish to filter by on the grid. A number 1 will be added on the grid menu for your first option chosen and a number 2 will be added on the second filtering option you chose. To add another filtering option hold the Shift key and click on the next field option you wish to filter by on the grid. A number 3 will be added on the grid on the third filtering option you chose.

Image Added

You can then enter in the filter option in the grid to filter the data-Example 1-Job Status-A for all Active employees, 2-Retirement Code-ST for all STRS employees, Code-05 for all Pay Group Code 05 employees.

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.

...