How to compare two strings?

How to compare two strings?

  

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

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

Solution