Need to get filtered records count and download filtered records in table
I have a table which is sourced from data page. I am using connect SQL and and saving the data from connect sql to data page. I am showing the data in table. I have turned on filters for some columns. I need to show the count of filtered records and also download the filtered records. Currently I am able to show the count of all records and download all the records but how to do it when we apply filters?
JPMorgan Chase
IN
Technically filters are applied over the UI not on the clipboard and it does not make a real time call to database.
If at all you need to do so. Alternative solution could be. get away with connect-sql . have a report definition with filter criteria editable.
configure report definition and have user to change the filter criteria as needed. this fill fire a real time database call and will have only the filtered results always in clipboard and the same will be exported as needed.