How to Access Filtered Datagrid Rows in WeWeb for Reporting?

Hi everyone! I’m facing an issue while working with the Datagrid.

I have a table with filters enabled (as shown in the screenshots below). I’m able to capture the applied filters using the Datagrid - filters variable, but what I actually need is to access the filtered data — meaning, the visible rows after the filters have been applied — so I can use them to generate a report.

I’m trying to retrieve this data inside a workflow triggered by the “On Filter Changed” event, but I can’t find a straightforward way to get the filtered dataset (only the filter conditions themselves).

Does anyone know how I can access the currently filtered rows from the Datagrid?

Any help is appreciated — thank you in advance!

1 Like

Hi Gilson, welcome back :waving_hand:

I tried replicating your use case and indeed I couldn’t get the data inside the filtered rows,

I’ll see if our tech team has an answer for this one.

Great question, @gilsonricardomr !

I’m really hoping for this feature as well. The new Datagrids are fantastic, but having access to the filtered list is essential. I often work with large datasets and want to let users bulk edit entries.

Right now, it’s quite confusing — when a filter is applied and the user clicks “Select All,” it selects the entire unfiltered dataset instead of just the visible, filtered items. This leads to unexpected results.

Do we know if this feature is on the roadmap? Or is there a recommended workaround in the meantime?

@gilsonricardomr I think figured out how you can access only the filtered items from your datagrid.

Set the Select All behaviour to Filtered instead of the default All.

Then in your workflow actions, you can access only the filtered items.

Hope this helps.

1 Like

Hey @sampannemans, thanks for the answer! Yes, this really works if the user clicks “select all”, but there should be some way to access the data that is being filtered and/or sorted, exactly as it appears in the datagrid, without requiring any additional action on the user’s part.

If it is showing in the list, it has to be saved somewhere, so that would be the access to that data.
This would be very interesting, especially for producing dynamic reports.

The way I managed to get around this was by leaving the filters external to the Datagrid.

1 Like