[Koha-bugs] [Bug 3521] Items table in catalogue/detail.pl and cataloguing/additem.pl is sorted nonsensically

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3521

Liz Rea <wizzyrea at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Attachment #8689|0                           |1
        is obsolete|                            |

--- Comment #17 from Liz Rea <wizzyrea at gmail.com> ---
Created attachment 9520
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=9520&action=edit
Bug 3521 - Items table in catalogue/detail.pl and cataloguing/additem.pl is
sorted nonsensically

Based on patch submitted by Ian Walls

Items were sorted by branch, then date accessioned, in GetItemsInfo.  While
this can be
helpful in some circumstances, more often it is useful for items to be sorted
first by
their enumchron (volume/issue, if applicable) then by their copy number.  This
patch changes the
sort on GetItemsInfo to branch, enumcrhon, copynumber then date accessioned.

As sorting on copynumber will be incorrect based on standard sorting ( e.g. 1,
10, 2, 20 ),
the copynumber is now padded with leading zeros to correct the sorting ( e.g.
01, 02, 10 20 ).
This function appears to be a standard SQL function and not a mysql-ism. I have
verfified
that is available in MySQL, Postgres, and Oracle.

Signed-off-by: Liz Rea <wizzyrea at gmail.com>
Passed t xt

Item sorts appear to be correct to me based on the rubric of branch, enumchron,
copynumber, then date accessioned.

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.