I have created a view to a large mysql table. I’m embedding it into my website and want to allow users to search the view and export records to CSV. This works fine but it exports all of the records. I want to limit how many can be exported to just the current page.
For example, the table has 50,000 records. When the view and export they can export all of them. I don’t want to allow this. I want to display 10 records per page and allow them to only download those 10.
Is this possible?