https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=44068 --- Comment #2 from Andrii Nugged <nugged@gmail.com> --- Created attachment 211473 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=211473&action=edit Bug 44068: Qualify log viewer date filters The log viewer's screen output joins item data, so an unqualified timestamp condition is ambiguous between action_logs and items. Setting either date limit therefore causes an API error. Qualify all three date-filter shapes with the main resultset alias. Keep the existing inclusive day boundaries and CSV behavior unchanged. Add an end-to-end Cypress test covering no dates, either date limit, and a date range against real action log entries. Test plan: Before applying the patch: 1. Go to Tools > Log viewer. 2. Click Submit with both date fields empty. Log entries should appear. 3. Click the Log viewer breadcrumb to return to the search form. 4. Set Display from to a date containing a known log entry. 5. Click Submit. The table fails to load with a 500 error. Apply the patch. After applying the patch: 1. Repeat steps 1-5 above. The dated entries should appear without an error, and the processing indicator should disappear. 2. Return to the search form using the Log viewer breadcrumb. 3. Clear Display from. 4. Set Display to to the same date. 5. Click Submit. Entries up to that date should appear. 6. Return to the search form using the Log viewer breadcrumb. 7. Set both date fields to the known entry's date. 8. Click Submit. Only entries from that day should appear. 9. Return to the search form using the Log viewer breadcrumb. 10. Select To a file with the same dates. 11. Click Submit. A CSV file should download. Automated tests: yarn cypress run --spec t/cypress/integration/Tools/LogViewer_spec.ts Co-Authored-By: Loontik <loontik@nugged.team> -- You are receiving this mail because: You are watching all bug changes.