...
Advanced Search 
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 '05/09/2008'. The user is searching for Employee's with a default activity date of 05/09/2008. 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 Boolean, the user would have to enter in true or false. 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 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
.
...
- Equals- equal
- One of - list of possible values; must be separated by commas
- Not equals-not equal
- Like - begins with
- Contains - consists of
- Positions example: "positionDescription.contains sub" will search for Positions with the word "sub" anywhere in the Position Description field.
- Between - range; values must be separated by commas
- Payments/Payroll:"paymentTransactions.payment.number.between 10247,10273" will search for Payroll numbers between 10247 and 10273
- is Null() - blank
- Not Null() - not blank
- Greater than- greater than
- Greater or equal - greater than or equal to
- Less than- less than
- Less or equal- less than or equal to
- Not one of - exclude list of possible values; must be separated by commas
- sort - to place in order; always places in ascending order only
- attendance example: "activityDate.sort" will sort attendance by activity date
- Type-See Property Fields below
...
Property Fields
Property is a field associated with the record the user is querying. Property field type is the 'type' of data being viewed. In the Positions, you will see all the Property fields associated with a positions and beside each property field it lists the type in parenthesis ().
...