Hi Jeyasri,

ListFilter works on in-memory Lists, using standard OutSystems Expressions. "like" is therefore not available.

JEYASRI R wrote:

It seams that you are filtering a screen list on the screen, why don't you just refresh the query?
If refresh Query doesn't for some reason work for you, try to use the dinamic link component. It Works great, and allows you to query over in-memory Lists.

Best Regards,

Hi Jeyasri,

Didn't think of it before, but you could use the built-in Index() Function in your Expression. Index() returns -1 if not found, and a positive number otherwise.

Hi,

You can try using Index(ClubName, Search) <> -1

-> https://www.outsystems.com/forums/discussion/26506/listfilter-usage/

Cheers,

Miguel Marçal

Hi Jeyasri,

What isn't working? Have you tried to find out why it's not working? (Note: it should work.)

Hai kilian,
I am used below the logic,That filter its not worked 

Can you show the content of ClubList2 ?  Are there even items there that match your filter ??  

(I don't see an aggregate in your flow that is populating it)

Sorry Jeyasri, I mean the data in debug right before executing the ListFilter Action

JEYASRI R wrote:

Hi JEYASRI,

SyntaxEditor Code Snippet

Index(ToLower(GetEmployees2.List.Current.Employee.Name),ToLower(SearchKeyword)) <> -1

Please refer below link

https://vermaamit52.outsystemscloud.com/ExcelPackageDemo/WebScreen1.aspx?_ts=636905170080126511

Thanks,

AV

Hi again,

Maybe you aren't getting any values because of the different characters case. Try this: Index(ClubList2.List.Current.Club.ClubName, Search, ignoreCase:True) <> -1.

If that doesn't work maybe you are doing it wrong. If you could provide us with the oml maybe we can help you more.

Best regards,

Miguel Marçal

Hi Jeyasi,

The filter condition should be

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

Regards,

Saugat

Hello Jeyasri, from what I see you need to use the ignore case:

Index( "First string", "f", ignorecase: True) = 0

So the filter will recognize what you need regardless of the uppercase or lowercase letter.

Hii JEYASRI, You can try this filter 

Index(ToBeSearchedFrom, SearchKeyword ,startIndex:,searchFromEnd:False,ignoreCase:True) <> -1