Hello everyone,
I'm encountering an issue while using the Aggregates feature in OutSystems and would appreciate some help.
Problem Description:
I am trying to add a filter condition in Aggregates using the Index function to check if a string contains a specific character, and I want this comparison to be case-sensitive. According to the OutSystems documentation, the Index function should support an ignoreCase parameter to perform case-insensitive comparisons.
However, when I try to use the ignoreCase parameter with the Index function in the filter condition, it doesn't seem to work.
Hello Yin,
As per OutSystems documentation this parameter is not used when you use Index function into aggregate:
Please check this link:
https://success.outsystems.com/documentation/11/reference/outsystems_language/logic/built_in_functions/text/#Index
Instead of ignoreCase parameter you can use ToLower or ToUpper functions like this example:
Index(ToLower("First string"), ToLower("f")) = 0