I only want to use the ListFilter function, but after trying to write an action, the result was not output correctly according to the conditions I wrote, and I don't know where the problem occurred.
What should I do? Can you help me？
Sorry my bad, left out this part to change the expression to display on the local table instead.
Optional changes below:
To filter the data from database, but since you're referring to the local table, and only 1 filter is applied, this will be optional in my opinion.
Kenny
Hi Naku,
You can try the following:
P/S: Remove the Sorting Attribute on header cell
Note that your filtered data will always be based on your aggregate. If you want to fetch from the latest data from database, you should implement the filter in the aggregate instead. Hope it helps, happy coding!
Hi, noticed that your age is in Integer type and your filter is trying to filter text type. If you want to filter and display on your screen, perhaps you can perform the following:
Thank you for your reply.
I want to use system action (ListFilter) in the Client Action, instead of adding filters in the DB，can you help me how shou I do?
I set it according to what you said, but the screen that comes out is not 21 but 18.
Hello @Naku Sitsu
I didn't opened your OML but i can refer you on the official Outsystems documetatioin for ListFilter action.
ListFilter
Returns a new list with the elements from the List parameter satisfying the given condition.
Inputs
SourceListType: mandatory, Generic Record List.
The list that contains the elements to which to apply the condition.ConditionType: mandatory, Boolean.
The boolean expression to check for on each element of the list.
Outputs
FilteredListType: Generic Record List.
A new list with the elements that satisfy the condition.
Official Documentation
I hope it'll help you.
ThanksDeep
I wrote it this way, but I'm not sure if there was something wrong with the settings inside that caused the function to not be implemented in the end. Can you teach me?
It's simple enough
Just paas your list which you want to filter set a condition and use listfilter output list,
This will be the filtered list.
@Naku Sitsu you should assign the out list which is coming from your list filter action.
Hi All 🙂
I have created a tutorial video explaining how List Filters works, with normal filter and also with Index function. Make sure to watch it.
https://youtu.be/M9ce_luUUWQ