...

• 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. All properties associated with the type of data you are querying will appear in the "Properties" box. If you hover over each property, it will show you the path to the field and the data type in parenthesis ().

• Integer-a whole number that can be positive, negative, or zero 
• String - a sequence of symbols or values, example of a string is an account number '1234567' or vendor name 'Sample'
• Boolean - true or false
• Calendar - is a date (YYYY/MM/DD, MM/DD/YYYY)
• big decimal - any fractional number
• int- a whole number that can be positive, negative, or zero 
• set - multiple values

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.

...