How do I access the filtered data of a table

You can access the entire data a table component is displaying through the data property. But I haven’t found a way to query the data after any user-defined filters on the table have been applied. Possible?

Hey @artman and welcome to the community! Right now there’s no direct way to reference something like table1.filteredData. One thing that might work though - you can reference the displayed table results with table1.displayedData - this will return whatever data is currently displayed in table1.

I built a quick example in the video below: the first table’s data is {{ query1.data }} and the second (lower) table’s data is {{ table1.displayedData }}. You can see that when I update the filters on table1, those changes carry through to table2 below.

Let me know if this helps!

Thanks, but I really needed to access the entire filtered content of the table. Something for the backlog I guess :wink:

These filters operate client side, so the displayed results are the entire filtered content. To filter your entire data set you’d need to do it server side / with a query.

table1.displayedData is showing everything in the table even though some of the columns are hidden. Is there a way to only access what is actually being displayed in the table?

I came across this and wanted to share a solution for querying only data that is visible in a table that has a client side filter (.displayedData) and has some columns hidden (based on the .columnVisibility property)
_.pick(formatDataAsObject(table3.displayedData),Object.keys(_.pickBy(table3.columnVisibility)) )