What are the available criteria types?

1. The available filtering criteria in the configuration tool.

1.1. equal

Using this criteria the data you are filtering on needs to be an exact match.

1.2. not equal

Using this criteria you would select a value you want filtered out of the data.

1.3. greater than

This criteria is typically used for numbers, you would use greater if you are looking for a value that is greater than what you set in the filter.

1.4. greater or equal than

This criteria is typically used for numbers, you would use greater or equal if you are looking for a value that is greater than or equal to what you set in the filter.

1.5. less than

This criteria is typically used for numbers, you would use less if you are looking for a value that is less than what you set in the filter.

1.6. less or equal than

This criteria is typically used for numbers, you would use less or equal if you are looking for a value that is less than or equal to what you set in the filter.

1.7. begins with

This criteria allows you to filter a field that begins with a letter(s) or number(s).

1.8. does not begin with

This criteria allows you to remove values in a field that begins with a letter(s) or number(s).

1.9. ends with

This criteria allows you to filter a field that ends with a letter(s) or number(s).

1.10. does not end with

This criteria allows you to remove values in a field that end with a letter(s) or number(s).

1.11. contains

This criteria allows you to filter values that contain somewhere in it the values you set in the filter.

1.12. does not contain

This criteria allows you to remove values that contain somewhere in it the values you set in the filter.

1.13. is null

This criteria allows you to filter out all records that have the specified field containing any data. Null is the absence of any data at all. (Note that 'NULL' is not the same as the integer 0. This is because 0 is data.)

1.14. is not null

This criteria allows you to filter out all records that have the specified field containing no data whatsoever. A field that has any bit of data in it can not be NULL. (Note that 'NULL' is not the same as the integer 0. This is because 0 is data.)

1.15. is in

This criteria allows you to only show records that have the specified field matching a value within a list of acceptable values.

1.16. is not in

This criteria allows you to filter out records that have the specified field matching a value within a list of acceptable values.

1.17. matches regular expression

This criteria allows you to only show records that have the specified field matching a regex expression.

1.18. does not match regular expression

This criteria allows you to filter out records that have the specified field matching a regex expression.