I've looked around all over the forum and the OutSystems documentation and I can't find anything on the ListFilter system function. I was hoping for some examples or more in depth explanation. Specifically I am wondering how the "Condition" field works. What can/cannot go in there? Is this iterating over the collection in a way that I could do something like the following?

SyntaxEditor Code Snippet

Rows.Row.Current.Type = "Income"

I'm imagining this working something like a C# Linq Where expression, but that's just an assumption based on what I want it to do.

Hello Trevor,

Here's an example usage of the filter action. Hope it helps.

Cheers,
R

Hi all,

i'm using the ListFilter action to filter a list but i'm not getting any results for the filtered list. The condition i'm using is the following:

User.UserName = "%" + Session.Polling_UserName + "%"

Cheers,

Rui

Rui Parente wrote:

User.UserName = "%" + Session.Polling_UserName + "%"

Hey Rui,

User.UserName = "%" + Session.Polling_UserName + "%"

This would work if it was SQL. (Though you'd have to change the = to a LIKE)

I would suggest using something like

Index(User.UserName, Session.Polling_UserName) <> -1

Cheers,

Joey

Zero wrote:

User.UserName = "%" + Session.Polling_UserName + "%"

User.UserName = "%" + Session.Polling_UserName + "%"

Index(User.UserName, Session.Polling_UserName) <> -1

Hey Joey,

I did just that and it worked perfectly.

Thanks

Rui