Skip to Content (Press Enter)
2019-04-11 03-16-59
Reynaldo Merino
4087Views
10Comments
ListFilter using Like
Question
OutSystems Widgets

Hi, I have a List and need to filter it with an input so each time a user types a letter an action should be executed and inside this action the list must be filtered by that letter o letters typed, for example:

List: Air, Back, Bank, Black, Boat, Cat, Dog..... 

If I type in my input the letter "B" i should get in my list:

FilteredList: Back, Bank, Black, Boat <-- And i will display this list again in a table

If I type another letter "Ba" i should get in my list:

FilteredList: Back, Bank

In this case "Module" is an Attribute from my List and I'm storing the value that i wnat to search in "Espace".


So my question is: Is it possible to use a wildcard like the reserved word "LIKE" to filter this list?

Something like:

Select * from clients

where client_name like 'Alf%'


Thanks for you help in advance.

Reynaldo


3
0
10 Oct 2018
Copy Link
2019-05-22 11-30-09
Marcelo Ferreira

Hi Reynaldo,

That work on SQL but on this actions you need to be more creative. Try this: Index(Module, Espace) <> -1

Regards,

Marcelo


8
0
10 Oct 2018
Copy Link
2019-04-11 03-16-59
Reynaldo Merino

Marcelo Ferreira wrote:

Hi Reynaldo,

That work on SQL but on this actions you need to be more creative. Try this: Index(Module, Espace) <> -1

Regards,

Marcelo


Thanks for your answer Marcelo, if i do what you suggest I will only get the position of the text that I'm looking for and I need to filter the list depending on the typed value to display the list on the table record widget.


0
0
10 Oct 2018
Copy Link
2019-02-04 17-50-13
Thiago Mendes da Silva

That worked for me.


Thanks, Marcelo.

0
0
24 Apr 2021
Copy Link
2023-07-20 04-07-44
Aditya Gaur

Reynaldo Merino wrote:

Hi, I have a List and need to filter it with an input so each time a user types a letter an action should be executed and inside this action the list must be filtered by that letter o letters typed, for example:

List: Air, Back, Bank, Black, Boat, Cat, Dog..... 

If I type in my input the letter "B" i should get in my list:

FilteredList: Back, Bank, Black, Boat <-- And i will display this list again in a table

If I type another letter "Ba" i should get in my list:

FilteredList: Back, Bank

In this case "Module" is an Attribute from my List and I'm storing the value that i wnat to search in "Espace".


So my question is: Is it possible to use a wildcard like the reserved word "LIKE" to filter this list?

Something like:

Select * from clients

where client_name like 'Alf%'


Thanks for you help in advance.

Reynaldo


Hi Reynaldo,

Use a richwidget: input_autocomplete , bind a textbox with  InputWidget.

In you screen actions, fetch data from clients. Loop it over a list, append values to list and then use 'Input_autocomplete_showlist.

You'll get your desire results.

Best,

AG



0
0
10 Oct 2018
Copy Link
2019-04-11 03-16-59
Reynaldo Merino

Aditya Gaur wrote:

Reynaldo Merino wrote:

Hi, I have a List and need to filter it with an input so each time a user types a letter an action should be executed and inside this action the list must be filtered by that letter o letters typed, for example:

List: Air, Back, Bank, Black, Boat, Cat, Dog..... 

If I type in my input the letter "B" i should get in my list:

FilteredList: Back, Bank, Black, Boat <-- And i will display this list again in a table

If I type another letter "Ba" i should get in my list:

FilteredList: Back, Bank

In this case "Module" is an Attribute from my List and I'm storing the value that i wnat to search in "Espace".


So my question is: Is it possible to use a wildcard like the reserved word "LIKE" to filter this list?

Something like:

Select * from clients

where client_name like 'Alf%'


Thanks for you help in advance.

Reynaldo


Hi Reynaldo,

Use a richwidget: input_autocomplete , bind a textbox with  InputWidget.

In you screen actions, fetch data from clients. Loop it over a list, append values to list and then use 'Input_autocomplete_showlist.

You'll get your desire results.

Best,

AG



Thanks for your answer AG but i don´t have table or aggregate named client, I have a list and I'm displaying values from this list to a table record widget.


0
0
10 Oct 2018
Copy Link
2019-05-22 11-30-09
Marcelo Ferreira

Hi Reynaldo,

Since you also have the <>-1 you know that the content of espace exists on module. If you want that module start with espace you just need to do =1

Regards,

Marcelo

3
0
10 Oct 2018
Copy Link
2022-06-28 17-31-40
Thiago Mota

Marcelo Ferreira wrote:

Hi Reynaldo,

Since you also have the <>-1 you know that the content of espace exists on module. If you want that module start with espace you just need to do =1

Regards,

Marcelo

Thanks Marcelo!


I also had this problem.

I used the ListFilter with Index(OriginalText, SearchText) <> -1 in condition.

It really worked!

Thank you again!


6
0
26 Dec 2019
Copy Link
2020-02-22 10-02-04
Allan Kedari

Replying to Thiago Mota's comment on 26 Dec 2019 13:58:34

Thanks Marcelo !

I used the ListFilter with Index(OriginalText, SearchText) <> -1 in condition. 

This Filter is working same as Like operator.


Thanks Alot !

3
0
28 Apr 2021
Copy Link
UserImage.jpg
pramod jain

Replying to Thiago Mota's comment on 26 Dec 2019 13:58:34


Index(Value,Search, ignoreCase:True) <> -1

Thanks It work.

0
0
11 May 2023
Copy Link
2024-06-19 07-19-32
JitendraYadav

Hi Reynaldo,


From where u are getting list like.aggregate or action ?


Thanks!


0
0
11 Oct 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.