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.