Question

list operation - filter date

1

Hello I try to filter a list as part of a microflow I retrieved the list. Now I added a list operation. - Operation: filter - selected the retrieved list - selected the date value to check - as EQUAL? Whow do I specifiy the filter to select all elements there the date is < then today?

asked 2020-12-04

Martin Bordt

4 answers

Toon Verschoor · Answer 1 · 2020-12-04

He Martin,

I don’t think you can. But how do you retrieve the list? Can’t you filter on it in that retrieve?

Monu Michael Jose · Answer 2 · 2020-12-05

Hi Martin,

Based on the requirement, a filter activity is not the right solution for this. You can easily get the list of entities based on a date condition using the Retrieve Activity in the Microflow.

As of the latest Mendix version, filter supports the equals to conditions only.

Martin Bordt · Answer 3 · 2020-12-07

Unfortunatelly if I retrieve by association, I have no filter option

Narayana Moorthy · Answer 4 · 2020-12-07

Hi martin ,

From the retrieved list you can put one loop for it and create one respective object list outside loop then check the respective datetime attribute inside the loop whether time is less than currentdate time ,

if its add in the list ,else dont add in the created list ,