When sorting clent-side DataTables-enhanced tables by title, it's possible to use a custom sorting algorithm to ignore articles, based on this configuration in datatables-strings.inc: var CONFIG_EXCLUDE_ARTICLES_FROM_SORT = _("a an the"); ...and the "anti-the" sorting code in js/datatables.js. This doesn't work with server-side DataTables implementations, which means that sorting by title on the circulation and patron detail pages no longer works as well as it did before those pages were redone with AJAX datatables. I would like to see some kind of implementation which continued to enable the user to define articles to exclude from sorting and would work at the database level so that AJAX datatables could be correctly sorted.
Created attachment 32093 [details] [review] Bug 13054: Added sort 'anti-the' to title
A tad confused... I just added the 'anti-the' to checkouts.js and found it appeared to be working for me.. See patch for the super tiny change.. Maybe i'm not looking in the right place though.
(In reply to Martin Renvoize from comment #2) > I just added the 'anti-the' to checkouts.js and found it > appeared to be working for me.. Yes, that works for me too. However, if I try to add something similar to manage-marc-imports.tt it doesn't work (Line 38): - { "mDataProp": "citation" }, + { "mDataProp": "citation", "sType": "anti-the" },
*** Bug 13070 has been marked as a duplicate of this bug. ***
A possible workaround for titles at least would be to respect the non-filing indications into the title field in the DB, or a new title_sort field - this would need to address the different MARC21/UNIMARC implementations