Exporting results with Views Data Export not working as intended

Question

I have a view-based search (drupal 7, newest version of Views) with several exposed filters. By default it shows all results and users have to use the filters to narrow down their search.

I've added 'Views Data Export' module to allow users to download search results via CSV export, if they wish. However it's not working as intended.

I created the export view and attached it to the search view fine. I made sure pager in the export view was set to 'display all items' (otherwise it only shows around 10 results).

I set batched export to yes. I also set each filter to 'remember last selection'.

However, no matter which filters are selected, the data export still shows every record in the database on export.

Anyone know how to fix this? Ideally the export would just show the records displayed on the screen after using the various filters.

Answer 1

A possible alternative to consider for the fix you are looking for, is to consider an alternative module that can possibly address all of your requirements, such as the Forena module. Here are a few features of it, which seem to be part of your requirements:

• Support for exposed filters (via report "parameters").
• Save reports (= query results) in CSV format (CSV is one of the supported document types).
• Create export view (= Write a report, e.g using the WYSIWYG report writer).
• Yes or no include a pager (using the dataTables plugin via report "skins", which also implements the search box feature that dataTables offers ...).

There are many more features that come with Forena, as detailed also in its Community documentation. Refer to the demo site for some sample reports (shipped with the module), or the documentation included with the module (such as the supported document types, of which CSV is just one of them).

Disclosure: I'm a co-maintainer of Forena,
I hope this does not violate the site's policy on self-promotion.

Answer 2

As @seb alluded to in his comment on the original post, you need to make sure the export display has the same exposed filters as the display you attach it to. If it does, it should automatically inherit the current exposed filter values when the user hits the export button.