Whenever you add criterion to report a filter on, you must assign a operator with the value.
Inform supports the following operators. Not all operators will be available with all data types:
- Equal to: Exact matches for any type of data. For example, Credit Status Equal to Active/Good returns all Customers with a good status, but not others.
- Not Equal to: Any value except the one specified. Applies to any type of data. For example. Credit Status Not Equal to Active/Status returns all customers with a credit status of Watch, COD, Legal, Hold, Cash in Advance, Inactive, Credit Card, Point of Sale, or Prospect.
- Greater Than: Numeric or date data. All values greater than the one specified or after the date specified.
- Less Than: Numeric or date data. All values less than the one specified or prior to the date specified
- Greater Than or Equal To: As above, but including the date or number specified.
- Less Than or Equal To: As above, but including the date or number specified.
- Begins With: Alphanumeric data starting with the digit or letter specified.
- Ends With: Alphanumeric data ending with the digit or letter specified.
- Contains: Alphanumeric data containing the digit(s) or letter(s) specified anywhere in the value.
- Does Not Contain: Alphanumeric data containing the digit(s) or letter(s) specified anywhere in the value.
See also