I have a table and I have a split button that filters the table based on a participation column I made. I want to be able to export the data as a csv/excel file that maintains the filter that is set. I noticed that when I apply a filter then export, the export is not dynamic and is not accounting for the filter I set, so all the data is being exported. I am currently using an export button with a dropdown to select csv or excel and using a utils.exportData() event handler upon click.
participation statuses: opt in or opt out
filter on split button:
All (shows all records that are both opted in/out)
opt in (shows only records that are opted in)
opt out (only records that are opted out)
apply opt in as filter on split button, only opt in records get exported to csv/excel
similar results for the other filters.