Ask AI
Skip to main content

Add a filter to a list of filters

Function: Add a filter to a list of filters​

This action allows you to build complex data filters by adding individual filter conditions to a collection. You can use these filter lists later to search and retrieve specific data from your built-in database, such as finding all "Products" that are "In Stock" AND have a "Price" "Less than" 50. If you start with an empty list, this action will create a new one for you.

Input​

  • Data format The type of data you want to filter (e.g., "Customers", "Orders", "Products"). This helps the platform understand which attributes are available for filtering.
  • List of filters (Optional) An existing list of filter conditions. If you provide a list, the new filter will be added to it. If you leave this empty, a new list will be created starting with your new filter.
    • Attribute: The specific field within your chosen Data format that you want to check (e.g., "Product Name", "Order Date", "Customer Status").
    • Operator: How you want to compare the Attribute to a Value. You can choose from options like:
      • Equal: Matches an exact value.
      • Greater than: Value is larger than.
      • Greater than or equal: Value is larger than or equal to.
      • In: Value is one of a list of values.
      • Less than: Value is smaller than.
      • Less than or equal: Value is smaller than or equal to.
      • Not equal: Does not match an exact value.
      • Not in: Value is not one of a list of values.
      • Contains: Text contains a specific phrase.
      • Contains \(ignore case\): Text contains a specific phrase, ignoring capitalization.
      • Starts with: Text begins with a specific phrase.
      • Ends with: Text ends with a specific phrase.
      • Is null: The attribute has no value.
      • Is not null: The attribute has a value.
    • Value: The specific data you want to compare against the Attribute. This field appears when the selected Operator requires a value (e.g., 'Equal', 'Greater than', 'Contains'). It will not appear for operators like 'Is null' or 'Is not null'.
  • Filter The new filter condition you want to add to the list. This is a single filter made up of an Attribute, an Operator, and optionally a Value.
    • Attribute: The specific field within your chosen Data format that you want to check (e.g., "Product Name", "Order Date", "Customer Status").
    • Operator: How you want to compare the Attribute to a Value. (Same options as above).
    • Value: The specific data you want to compare against the Attribute. This field appears when the selected Operator requires a value (e.g., 'Equal', 'Greater than', 'Contains'). It will not appear for operators like 'Is null' or 'Is not null'.

Output​

  • Filter list The updated list of filter conditions, including the newly added filter. This list can then be used in other actions to query your database.

Execution Flow​

Real-Life Examples​

Example 1: Starting a new filter list for active customers​

You want to find all customers who are currently "Active" in your system.

  • Inputs:
    • Data format: Customers
    • List of filters: (Leave empty)
    • Filter:
      • Attribute: Status
      • Operator: Equal
      • Value: Active
  • Result: A new filter list is created containing one condition: Customers.Status = 'Active'. This list is available as Filter list for subsequent actions.

Example 2: Adding a second condition to an existing filter list​

Building on Example 1, you now want to find active customers whose accounts were created after a specific date.

  • Inputs:
    • Data format: Customers
    • List of filters: (The filter list from Example 1: Customers.Status = 'Active')
    • Filter:
      • Attribute: Creation Date
      • Operator: Greater than
      • Value: 2023-01-01
  • Result: The existing filter list is updated to include both conditions: Customers.Status = 'Active' AND Customers.Creation Date > '2023-01-01'. This updated list is available as Filter list.

Example 3: Adding a filter for products with a specific keyword in their name​

You want to find products that have "Pro" in their name, regardless of capitalization.

  • Inputs:
    • Data format: Products
    • List of filters: (An existing list, or leave empty to start a new one)
    • Filter:
      • Attribute: Product Name
      • Operator: Contains \(ignore case\)
      • Value: Pro
  • Result: The filter list is updated to include the condition: Products.Product Name contains 'Pro' \(case-insensitive\). This updated list is available as Filter list.