Is Alphanumeric Comparison Supported in Fetch Entities Step?

Can we use greater than or less than operators for alphanumeric string comparison in the Fetch Entities step? We want to filter data based on alphanumeric ranges, like checking if a cost center value falls between two other alphanumeric values.

Comments

  • The Fetch Entities step is not designed to handle alphanumeric comparisons using operators like < or >. These operators are typically available for numeric fields, and when using string fields, the behavior is not supported or consistent.

    For use cases requiring string range checks (e.g., verifying if "KKHLKY05" falls between "KKHLKY01" and "KKHLKY09"), it is recommended to use Parameterized Query Integration instead. This allows more flexibility with SQL logic, including lexicographical comparisons or even wildcards.

    Suggested Resolution:

    • Create a parameterized query with the return data option set to "Select Type".
    • Use standard SQL string comparison logic within the query.
    • Integrate the query into your flow using a Query Integration step.

    📘 Documentation Reference:

    Parameterized Queries in Decisions

    This approach is more scalable and suitable for complex conditions, especially when working with large datasets or external databases.

Sign In or Register to comment.