...
- %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
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.
...
If a user doesn't want to leave the grid and instead wants a quick view of a particular row's details, click anywhere on the row and a highlight view box will appear on the right side of the grid displayed the more popular properties.
Advanced Query
Advanced Search The 
is a more elaborate search where the user selects the property field to search on, the operation to search by, and enters what they are searching for. For example in the Attendance Advance Search, Select Property of 'Activity Date', Select Operation of 'Equals', and a Filter Value of '0512/0919/20082017'. The user is searching for Employee's with a default activity date of 0512/0919/20082017. The Filter Value is a value entered by the user based on what they are searching for and the property field type; for some operations this may be a list or range with the values separated by commas. The information entered in the Filter Value box is dependent on the property field selected. If the user chooses a property field of type Boolean, the user would have to enter in true or false.
The user can add as many search lines as desired by dragging and dropping them in the desired order into the Display box or double clicking the Properties. The Search properties can be 'Removed' by clicking on the
.
The Advanced Advance Query searches can be saved and recalled later. The Query can be saved by entering in a Query Name and clicking on '
'. Then the Query can then be reloaded using the 
- 'Apply Query' starts the search
- 'Clear Query' clears the search items and returns all the original values back to the grid
- 'Hide Advanced Query Controls' hides the Advanced Search Query window
...
Mass Change
Example of adding a Stop Date on a Payroll Item:
...
To save the Script Definition, enter a name in the Definition Name and click on 
. This definition can then be used again for just that Payroll Item (example.. OSDI Tax Item) that was selected by clicking on
To Execute the load, click on 
option. Once this has been selected, it will show how many records will be modified 
. Verify and click on 
...
Filter Value - is a value entered by the user based on what they are searching for and the property field type; for some operations this may be a list or range with the values separated by commas.