Filter Table Export Data by displayed columns

💬 App Building
, , ,
1

Hi,

I want to filter the exported data form a table by displayed colums. I have different views for one column, depending on a select component. Now I want to filter the data for the export by displayed colums (I want to hide the data of the hidden columns).
I realized, I have to do this with a transformer:

Here I can get tot total data:

const total_data = {{ table1.data }}

But I can't find the data in table1 if a column is hide or not. I can only find the total {{ table1.hidden }}.

Could anybody help?

Thanks a lot!

2

Hi,

You could use table1.getDisplayedData({includeHiddenColumns:false}) but i think it could only be used in a query JS not in a transformer.

I usually do a return of this data in a query and add an export data in the success event handler.

hope that'll help

1 Like
3

@Julien_COLOMBEAU thanks a lot! You are the best! :rocket:

2 Likes