The Advanced Query/Customization query function provides Filters that allow you to control what data is returned by the query. The filters are.
Contains | The contents of the Value field appears somewhere in the database row of the Field being queried. Used primarily for fields containing text data. Contains is the default Filter option. Note: Contains does not work for date fields (Action Date, Export Date, etc.). |
Equal To | The contents of the Value field exactly matches the contents of the database row of the Field being queried. |
Less than or Equal to | The contents of the Value field is less than or equal to the contents database row of the Field being queried. |
Greater than or Equal to | The contents of the Value field is greater than or equal to the contents database row of the Field being queried. |
Begins with | The contents of the database row of the Field being queried starts with the contents of the Value field. |
Ends with | The contents of the database row of the Field being queried ends with the contents of the Value field. |
Greater than | The contents of the Value field is greater than the contents database row of the Field being queried. |
Less than | The contents of the Value field is less than the contents database row of the Field being queried. |
Not equal to | The contents of the Value field does not exactly matches the contents of the database row of the Field being queried. |