Bug 40111

Summary: Fix title sorting on two reports
Product: Koha Reporter: Owen Leonard <oleonard>
Component: TemplatesAssignee: Owen Leonard <oleonard>
Status: Pushed to oldstable --- QA Contact: Marcel de Rooy <m.de.rooy>
Severity: minor    
Priority: P5 - low CC: anneli.osterman, fridolin.somers, m.de.rooy
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: Trivial patch Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
25.11.00,25.05.02,24.11.08
Circulation function:
Attachments: Bug 40111: Fix title sorting on two reports
Bug 40111: Fix title sorting on two reports
Bug 40111: Fix title sorting on two reports

Description Owen Leonard 2025-06-10 15:47:58 UTC
Two reports output titles but don't use the DataTable "anti-the" option for sorting titles while excluding articles: Items lost and orders by fund.
Comment 1 Owen Leonard 2025-06-10 15:56:28 UTC
Created attachment 183140 [details] [review]
Bug 40111: Fix title sorting on two reports

This patch modifies two reports in order to correct sorting on title
columns.

To test, apply the patch and got to reports -> Lost items.

- Run the report with parameters that will return multiple results.
  - Test sorting the title column. The articles 'a', 'an', and 'the'
    should be ignored.
- Perform the same test with the "Orders by fund" report.

Sponsored-by: Athens County Public Libraries
Comment 2 OpenFifth Sandboxes 2025-06-11 13:05:24 UTC
Created attachment 183160 [details] [review]
Bug 40111: Fix title sorting on two reports

This patch modifies two reports in order to correct sorting on title
columns.

To test, apply the patch and got to reports -> Lost items.

- Run the report with parameters that will return multiple results.
  - Test sorting the title column. The articles 'a', 'an', and 'the'
    should be ignored.
- Perform the same test with the "Orders by fund" report.

Sponsored-by: Athens County Public Libraries
Signed-off-by: Anneli Österman <anneli.osterman@koha-suomi.fi>
Comment 3 Marcel de Rooy 2025-07-09 14:28:40 UTC
Created attachment 183894 [details] [review]
Bug 40111: Fix title sorting on two reports

This patch modifies two reports in order to correct sorting on title
columns.

To test, apply the patch and got to reports -> Lost items.

- Run the report with parameters that will return multiple results.
  - Test sorting the title column. The articles 'a', 'an', and 'the'
    should be ignored.
- Perform the same test with the "Orders by fund" report.

Sponsored-by: Athens County Public Libraries
Signed-off-by: Anneli Österman <anneli.osterman@koha-suomi.fi>

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Comment 4 Lucas Gass (lukeg) 2025-07-11 21:29:35 UTC
Nice work everyone!

Pushed to main for 25.11
Comment 5 Paul Derscheid 2025-07-24 08:20:16 UTC
Nice work everyone!

Pushed to 25.05.x
Comment 6 Fridolin Somers 2025-07-31 12:48:56 UTC
Pushed to 24.11.x for 24.11.08