Bug 6655 - Sorting order of serial issues in OPAC
Summary: Sorting order of serial issues in OPAC
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Serials (show other bugs)
Version: 3.8
Hardware: All All
: P5 - low trivial
Assignee: Meenakshi
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-01 13:41 UTC by vimal kumar
Modified: 2013-12-05 20:06 UTC (History)
8 users (show)

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


Attachments
Attaching Patch. (859 bytes, patch)
2012-05-23 05:27 UTC, Meenakshi
Details | Diff | Splinter Review
Bug 6655 - Sorting order of serial issues in OPAC (932 bytes, patch)
2012-07-11 20:03 UTC, Elliott Davis
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
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