[Evergreen-catalogers] Fix available for "manage authorities" view sorting bug

[Yamil Suarez]

Hello,

Mike Rylander recently wrote some new code to address a "manage authorities" view sorting bug[1][2]. I had mentioned the bug before to this list, so I wanted to give an update to this group. I tried out the code on my EG 2.4 test server using my production data and it seemed to work fine[3].

I asked Mike how well his code would work with older versions of Evergreen and Mike's said…

"…
> Would it be hard to port this code for older versions of EG? Thankfully, we are on 2.4 so I would like to add this to my production server sooner than later.
> 

If you're fine with reingesting your authority records, you can toss
the changes on anything 2.2+, I believe.  Certainly 2.4 is fine.  My
understanding is that there's general community consensus against
requiring any reingest within a release, so it probably won't get into
a 2.4.x release, but it'll work fine.

--miker
…"


If you or your local developer/sysadmin are interested in trying the code on a test system, you can follow the following email thread with information on how to do it before the fix makes it to EG 2.5.

	http://georgialibraries.markmail.org/thread/4h7pmgjxlv3iyw26

Here is a copy of the SQL code I used to put in the fix, and then I triggered a re-ingest of all my auth records.

	https://docs.google.com/file/d/0B4URatF-NX5LeXpsbWxLd3Z5R2s/edit?usp=sharing

Good luck,
Yamil

[1] Code fix Git branch
http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/miker/authority-sf-file-order



[2] Subfields in Manage authorities not alphabetized
https://bugs.launchpad.net/evergreen/+bug/781008



[3] Here are some sample screenshots of a system with and without Mike's fix…

1) Search for subject authorities: Jazz

- without fix
http://www.flickr.com/photos/98246313@N05/9184401009/

- with fix
http://www.flickr.com/photos/98246313@N05/9186620516/



2) Search for subject authorities: Jazz France

- without fix
http://www.flickr.com/photos/98246313@N05/9186620492/

- with fix
http://www.flickr.com/photos/98246313@N05/9184400967/



3) Search for author authorities: Bach

- without fix
http://www.flickr.com/photos/98246313@N05/9184401093/

- with fix
http://www.flickr.com/photos/98246313@N05/9184401065/