Comparing Values

Custom filters allow users to compare values based on specific requirements. Every applied filter consists of three sections:

1. Field Name: The field where the filter will be applied.
2. Comparison Method: Defines how values will be compared.
3. Values: The actual data to compare against. Please see following image for reference:
   

The Comparison Method list provides various options to tweak filter behavior. Below are the available methods:

• Any Of: Filters data where any value in the comma-separated list matches.
  Example: To filter vehicles where the make is either Audi, BMW, or Toyota, select "Any Of" and enter Audi,BMW,Toyota (without spaces) in the value field.
• None Of: Filters data where none of the values in the list match.
  Example: To exclude Audi, BMW, and Toyota from the list, select "None Of" and enter Audi,BMW,Toyota in the value field.
• Contains: Filters records where the specified value is present within the field.
  Example: To filter vehicles where the Description contains "Automatic," select "Contains" and enter Automatic.
  Note: This method does not support multiple values (e.g., "Automatic,Manual").
• Does Not Contain: Opposite of "Contains." Filters data where the specified value does not appear anywhere in the field.
• Equals: Filters data where the field value exactly matches the provided value.
• Not Equals: Filters data where the field value does not match the provided value.
• Greater or Eq.: Used for numeric fields to filter values greater than or equal to a specified number.
  Example: To filter vehicles where the selling price is at least 100,000, select "Greater or Eq." and enter 100000.
• Less or Eq.: Similar to "Greater or Eq.," but filters values less than or equal to the specified number.