Bug 6655

Summary: Sorting order of serial issues in OPAC
Product: Koha Reporter: vimal kumar <vimalibre>
Component: SerialsAssignee: Meenakshi <meenakshi.r>
Status: CLOSED FIXED QA Contact: Bugs List <koha-bugs>
Severity: trivial    
Priority: P5 - low CC: chris, elliott, kyle.m.hall, melia, nengard, paul.poulain, savitra.sirohi, tdavis
Version: 3.8   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10158
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Attaching Patch.
Bug 6655 - Sorting order of serial issues in OPAC

Description vimal kumar 2011-08-01 13:41:29 UTC
OPAC displays the journal issues follows the order of data in which received.

e.g.

Vol 45, Issue 1
Vol 45  Issue 3
Vol 45 Issue  2
Vol 45 Issue  4



OPAC does not display issues in sequential order.
Issues in sequence is convenient for users to identify availability easily.


e.g.

Vol 45, Issue 1
Vol 45  Issue 2
Vol 45 Issue  3
Vol 45 Issue  4
Comment 1 Nicole C. Engard 2011-08-03 00:04:10 UTC
Vimal,

There is a table sorter at the top of every column so you can sort them in order if you want to.  But I do agree that it would be nice if they were in order (I'd say descending order - newest first) by default.

Nicole
Comment 2 Savitra Sirohi 2012-03-19 14:40:22 UTC
Might as well do this in the staff interface as well for consistency.
Comment 3 Savitra Sirohi 2012-03-29 13:01:55 UTC
Design: we will change the default sort order, table sorters or datatables can be used to resort the data once the screen is displayed.
Comment 4 Melia Meggs 2012-05-01 17:24:42 UTC
Hi Savitra,

Kyle is worried that the enumeration data ( volume, number, etc. ) are all stored in a single field "Publication Details" aka "Serial Enumeration / chronology". Sorting on that field might not be good as the numbers are not padded ( e.g. we see '2' not '002' ).

He thinks right now the results are sorted by the home library name, then the date
accessioned, and he's not sure if we can get any better than this without a major
overhaul to the serials system.

Is this so, or do you have some other idea for how to solve this problem?

Thanks,

Melia
Comment 5 Savitra Sirohi 2012-05-03 03:39:51 UTC
Melia, we were thinking we will sort it on publication date instead of receive date. This should sort the items in proper order (Vol, Issue etc.). 

What do you think?
Comment 6 Kyle M Hall 2012-05-03 17:31:16 UTC
(In reply to comment #5)
> Melia, we were thinking we will sort it on publication date instead of
> receive date. This should sort the items in proper order (Vol, Issue etc.). 
> 
> What do you think?

Another possibility is to use regular expressions to pad out all those numbers to say 10 zeros on a copy of the field, then sort by that copy of the field.
Comment 7 Meenakshi 2012-05-23 05:27:25 UTC Comment hidden (obsolete)
Comment 8 Elliott Davis 2012-07-11 20:03:35 UTC
Created attachment 10775 [details] [review]
Bug 6655 - Sorting order of serial issues in OPAC

Works as advertised.

Signed-off-by: Elliott Davis <elliott@bywatersolutions.com>
Comment 9 Paul Poulain 2012-08-02 10:09:19 UTC
QA comment: tiny -and logical- change, passed QA
Comment 10 Paul Poulain 2012-08-02 10:12:56 UTC
I think it's more a trivial bugfix than an ENH: sorting by publisheddate is logical. sorting by expecteddate is not
Comment 11 Chris Cormack 2012-08-02 21:31:20 UTC
Pushed to 3.8.x will be in 3.8.4