...
- 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 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
...