Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  • To find values that are blank, use the Advance Query option.  Select the Operation: Is_Null with a filter value of ()       

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.

...