- Issue created by @acbramley
- 🇦🇺Australia acbramley
Further debugging reveals this may be due to exposed filters not functioning correctly anymore.
I fired up a Vanilla Drupal site on 10.2.0 with this module installed and no patches and batch exporting seemed to work fine. However, if I applied a filter (e.g Title on the Content view) and then exported, all rows were exported, i.e the result set was not filtered.
Next I managed to get the full SQL query from my client site that had the fully broken exports and it looks like conditions are being added to the SQL query that are not present (i.e empty filters are being applied to the SQL query, effectively returning no results):
WHERE (media_field_data.name LIKE '%%' ESCAPE '\\') AND (media_field_data.status = '1') AND ((media_field_data.status = 1 OR (media_field_data.uid = 1 AND 1 <> 0 AND 1 = 1) OR 1 = 1 OR 1 = 1)) AND (file_managed_media__field_media_file.uri LIKE '' ESCAPE '\\') AND (media__note.note_value LIKE '' ESCAPE '\\')
That's for a Media view where I have exposed filters for media Name, File uri and a field on the media called Note. Notice all WHERE conditions have empty values, even the name filter where I had submitted a non empty value.
- 🇨🇦Canada leducdubleuet Chicoutimi QC
Same problem here. I guess this could be considered a duplicate of Exposed filter values ignored when using batch 🐛 Exposed filter values ignored when using batch Needs work ...
- Status changed to Closed: duplicate
over 1 year ago 9:05pm 19 December 2023 - 🇦🇺Australia acbramley
Dupe of 🐛 Exposed filter values ignored when using batch Needs work