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.
Howdy, Stranger!
Categories
- 4.3K All Categories
- 74 General
- 13 Training
- 206 Installation / Setup
- 1.1K Flows
- 110 Rules
- 268 Administration
- 212 Portal
- 496 General Q & A
- 709 Forms
- 344 Reports
- 3 Designer Extensions
- 48 Example Flows
- 57 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 184 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 229 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 58 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions