686
Views
1
Comments
Solved
How to compare two strings?
Question

I had an aggregate and I need to compare the record with a text that the user put in a text input, I have to consider the upper case and the lower case, please help! I'm a begginer with outsystems

2018-06-11 09-12-53
Rodrigo Coutinho
Staff
Solution

Hello Leidy,

The comparison on the aggregates should be case insensitive, so no need to worry about case.

If you want an exact match, you can compare using =

entity.attribute = inputVariable

If you want a a "fuzzy" match, you can use the like operator, together with the wildcard operator %

entity.attribute like "%" + inputVariable + "%"

Cheers,
R

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.