...

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

Search Operations

Operation is a process or validation to determine a particular presence or quantity:

• 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

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

Property Fields 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 ().

...