The conversion in the Aggregate filter using LongIntegerToIdentifier(TextToLongInteger()) isn't work
124
Views
3
Comments
Out of scope
Aggregates & Queries

In some scenarios, we receive the Id from an API as a text data type, and we need to use it to filter records in an Aggregate. To handle this, we convert the text to a long integer using TextToLongInteger() and then to an identifier using LongIntegerToIdentifier() to match against Table.Id. However, this conversion occasionally fails, especially in the production environment . In such cases, the Aggregate filter fails to return the expected results, likely due to type mismatches or runtime issues with the conversion process. This inconsistency makes it challenging to filter data accurately when dealing with dynamic or external data sources 
Please consider improving this feature by adding native support for safe and consistent type conversion within Aggregates. This would help ensure reliable filtering, especially when working with dynamic or external data sources, and reduce unexpected issues in production environments. 

Totally agree, Sometimes even IntegerToIdentifier(TextToInteger(Value)) also not works. 

Nice Observation @VenkatesaiyaSafe type conversion in Aggregates would improve filtering with external text-based IDs. 

Changed the status to
Out of scope

If a built-in feature doesn't work than you should use the feedback opton in service studio, and create a support case.