Bug 13722 - Titles with articles not sorting correctly in lists
Summary: Titles with articles not sorting correctly in lists
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Lists (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal with 23 votes (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-17 21:40 UTC by Jesse Maseto
Modified: 2024-03-26 18:49 UTC (History)
13 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jesse Maseto 2015-02-17 21:40:03 UTC
We've noticed that in lists sorted by title, titles with articles, e.g., that being with "The..." are sorting under the article even though the second indicator of the 245 field is set correctly.  E.g. this list, "Lighthouses (West Coast)":

http://keys.bywatersolutions.com/cgi-bin/koha/opac-shelves.pl?sortfield=title&viewshelf=66&itemoff=3
Comment 1 Owen Leonard 2015-02-19 13:39:54 UTC
This bug could just as easily be titled "Teach Koha how to ignore nonfiling characters," because Koha doesn't take nonfiling characters into account at all. As far as I understand it, Zebra can be configured to ignore certain stop words, and some tables which are sorted by JavaScript are configured to ignore articles on titles. Anything which is sorted by MySQL is going to be ignorant of stop words or nonfiling characters.
Comment 2 Holly 2020-02-14 10:24:04 UTC
Based on the last comment there doesn't seem much can be done for this right now, but I wanted to register that there is still interest in it.
Comment 3 Laura Horgan 2020-06-22 17:07:22 UTC
Looks like this was fixed with elasticsearch so wondering if someone should look at this one as well bug number 22771
Comment 4 Katrin Fischer 2020-06-22 20:38:57 UTC
(In reply to Laura Horgan from comment #3)
> Looks like this was fixed with elasticsearch so wondering if someone should
> look at this one as well bug number 22771

This is a different problem here:
Result lists can sort correctly depending on the indicators of 245 for Zebra and Elasticsearch, but the lists result set is not created using either of those. It's created with SQL and therefore we need a completely different fix here.
Comment 5 Lucy Vaux-Harvey 2020-09-15 10:00:08 UTC
This issue has also been reported by one of our customers.  It would be great to have a fix so that the second indicator was taken into account.
Comment 6 Katrin Fischer 2020-09-15 10:08:15 UTC
I think the best we could do here is probably to use the anti-the list, that we have for other SQL based title lists? Only the search results from Zebra/Elasticsearch can use the indicators.
Comment 7 Abbey Holt 2021-03-10 19:41:26 UTC
I second Holly and Lucy. We would love to see this, too!
Comment 8 adzmau 2024-02-16 19:41:15 UTC
It'd be great to see this issue fixed, so that the second indicator was taken into account. Titles with articles are incorrectly sorting in my Lists.