Breadcrumbs

String


Contains

  • Definition: Checks if the string contains a specific substring.

  • Use Case: Useful for partial matches.

    Example: Filter customers whose product category contains "shoes".

    • product_category Contains "shoes" → Matches running shoes, formal shoes.

NotContains

  • Definition: Checks if the string does not contain a specific substring.

  • Use Case: Excludes strings with certain substrings.

    Example: Exclude customers whose product category contains "accessories".

    • product_category NotContains "accessories" → Excludes fashion accessories.

EndsWith

  • Definition: Checks if the string ends with a specific substring.

  • Use Case: Useful for domain-specific filtering or suffix-based matching.

    Example: Filter product SKUs that end with "-XL".

    • product_sku EndsWith "-XL" → Matches SHIRT-XL, PANTS-XL.

StartsWith

  • Definition: Checks if the string starts with a specific substring.

  • Use Case: Useful for prefix-based filtering.

    Example: Filter product SKUs that start with "SHIRT".

    • product_sku StartsWith "SHIRT" → Matches SHIRT-XL, SHIRT-M.

Equals

  • Definition: Checks if the string is exactly equal to a specific value.

  • Use Case: Useful for exact matches.

    • Example: Filter customers whose country is "Netherlands".

      • country Equals "Netherlands" → Matches Netherlands.

NotEquals

  • Definition: Checks if the string is not equal to a specific value.

  • Use Case: Excludes exact matches.

    • Example: Exclude customers whose country is "Germany".

      • country NotEquals "Germany" → Excludes Germany.

EqualsOneOf ("In" Filter)

  • Definition: Checks if the string matches one of the values in a predefined list.

  • Use Case: Useful for matching against multiple possible values.

    • Example: Filter customers whose country is either "Netherlands", "Belgium", or "Germany".

      • country EqualsOneOf ["Netherlands", "Belgium", "Germany"] → Matches Netherlands, Belgium, Germany.

EqualsNoneOf ("NotIn" Filter)

  • Definition: Checks if the string matches none of the values in a predefined list.

  • Use Case: Excludes multiple specific values.

    • Example: Exclude customers whose country is "Netherlands" or "Belgium".

      • country EqualsNoneOf ["Netherlands", "Belgium"] → Excludes Netherlands, Belgium.

IsEmpty

  • Definition: Checks if the string is empty (i.e., no value is present).

  • Use Case: Useful for identifying missing or incomplete data.

    Example: Filter customers who have not provided a product category.

    • product_category IsEmpty → Matches customers with no product category.

IsNotEmpty

  • Definition: Checks if the string is not empty (i.e., a value is present).

  • Use Case: Useful for ensuring data completeness.

    Example: Filter customers who have provided a product category.

    • product_category IsNotEmpty → Matches customers with a product category.