This suggests that php sessions are not working on your site. I would suggest you contact your web host and ask them about cookie-based php sessions, see if there is anything special you need to do to get them working.
Another possibility is there is some kind of server caching that is preventing the export from getting the current filter settings.
This will affect other operations in the plugin so it’s important you get this working.
Thanks for your prompt reply. I will contact my host tomorrow, I’m in the UK so out of hours now and support is only really for emergencies. I have Autoptimize running, but have just deactivated that to see if that is causing a cache problem, but it made no difference.
Thanks again, I will update this with anything I find.
David
As an update to this, after a lot of head scratching and searching, I have discovered that the issue of filtering not working on the Exported CSV is a conflict with another plugin, User Submitted Post Pro (USP Pro). With USP Pro deactivated the Export CSV matches the filtered results and works fine. As soon as I activate USP Pro the problem returns except the last working filtered results are downloaded, rather than the entire database as I originally reported. To test this further I used a clean install of WP in a subdirectory of my site. The free version of USP does not have this effect on PDB. Have you got any ideas? I will raise a similar request to the USP Pro plugin author. Thanks David
The most likely explanation for this issue is that the other plugin is not allowing Participants Database to use the php sessions normally. This will likely show up in the error log as a session handler that could not be properly initialized.