How to pass filtered data in table to a microflow?

0
I have a dataview with multiple columns, the user can filter the table columnwise. There is a column total, sum of whose values i am displaying at the bottom of the table. If user filters the table, how do i pass these filtered values to the microflow so only the sum of filtered total appears?   (above screenshot is without any filters)   (above image after applying filter) only one row is coming after the filter with total 554. So i want the total cost to show 554 only
asked
2 answers
1

Hi,

 

First you can check this one  https://community.mendix.com/link/space/microflows/questions/129867

 

The first thing that comes to my mind is a bit complex, I hope I can explain it;

I will explain it in headings without going into details,

Do not use gatagrid filters for filter, instead, create a "Non-persistable helper entity" and use it for filter. In this helper entity, create the attributes you want to filter and the "total cost" attribute to show to the end user.

On the page, create the helper entity with microflows and dataview and use the attributes in the helper. The microflows operation I mentioned below will also be done in this microflows.

Place your own datagrid in the helper data view, then filter the attributes in this helper by matching (using Contains) with Xpath in your datagrid.

Then, in the Helper dataview microflows, retrieve your data in microflows using the same filter operation in the datagrid and place the result you get by counting to the "total cost" in the helper.

Good luck  

answered
0

Hi Pranav,

You have to make your own custom filter.

Try this 

https://medium.com/mendix/create-your-own-way-of-filter-by-npe-non-persistant-entity-and-microflow-4ffd11e52fb0

answered