Skip to Content (Press Enter)
UserImage.jpg
ujwala T
175Views
3Comments
Solved
Search in listflter
Question
1-Click Publish

Hi All,

I want to use like operator like aggregate,

Ex username like %admin% or userName like "%st% based on searchvalue

Please suggest

1
0
03 Apr 2023
Copy Link
2024-10-07 06-43-19
Aanchal Sharma
Solution

Index(ToUpper(value which you want to search), ToUpper(SearchText var which store search text)) <> -1 

here is screen shot where i used this for serach in list which work fine for me.

See solution in context
1
0
03 Apr 2023
Copy Link
2024-12-10 04-40-04
Gitansh Anand

Hi @ujwala T, try using the Index built-in function provided by OutSystems.

Here is an example to use in the list filter:

Index(userName, YourText) <> -1

You can also set ignore case if you want to.

Thanks
Gitansh Anand

0
0
03 Apr 2023
Copy Link
2022-06-23 06-21-50
Siddharth Vyas

Hey Hi,
Please refer to the mentioned image below. And let me know if its working.

Thanks 

image_2022_12_16T09_59_17_748Z.png
0
0
03 Apr 2023
Copy Link
2024-10-07 06-43-19
Aanchal Sharma
Solution

Index(ToUpper(value which you want to search), ToUpper(SearchText var which store search text)) <> -1 

here is screen shot where i used this for serach in list which work fine for me.

1
0
03 Apr 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.