ListFilter usage

  

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.

Solution

Hello Trevor,

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

Cheers,
R

Solution

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:

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

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:

Rui Parente wrote:

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

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


Hey Joey,

I did just that and it worked perfectly.

Thanks

Rui