https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 Eric Phetteplace <ephetteplace@cca.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ephetteplace@cca.edu -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |26664 See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=19915 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26664 [Bug 26664] Inventory: Sorting column 'Last seen' goes wrong -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |Academy Assignee|koha-bugs@lists.koha-commun |katrin.fischer@bsz-bw.de |ity.org | --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I used LOC and they are sorting now as described in the example, will upload a patch. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 111952 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=111952&action=edit Bug 25897: Use cn_sort for sorting callnumbers in inventory table Instead of using the machine sortable form of the callnumber from cn_sort the table was only sorting on the callnumber. This tries to fix it using the same technique as for sorting the differently formatted dates. To test: - If your database has items with suitably cataloged items, use these. Otherwise you could use the examples from the bug report: - Catalog items with the following barcodes: B 29 V55 1998 B29 .C55 2008 B29 .L24 1983 B29 .L264 1998 B29 .P666 2004 Make sure the LOC is selected in $2 as source of classification This makes sure the sortable form of the callnumber is calculated correctly. - Go to inventory - Search for your items - Before patch, they should sort on callnumber as above, after the patch the correct sort order should be: B29 .C55 2008 B29 .L24 1983 B29 .L264 1998 B29 .P666 2004 B 29 V55 1998 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #112684|0 |1 is obsolete| | --- Comment #6 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Created attachment 112892 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=112892&action=edit Bug 25897: Use cn_sort for sorting callnumbers in inventory table Instead of using the machine sortable form of the callnumber from cn_sort the table was only sorting on the callnumber. This tries to fix it using the same technique as for sorting the differently formatted dates. To test: - If your database has items with suitably cataloged items, use these. Otherwise you could use the examples from the bug report: - Catalog items with the following barcodes: B 29 V55 1998 B29 .C55 2008 B29 .L24 1983 B29 .L264 1998 B29 .P666 2004 Make sure the LOC is selected in $2 as source of classification This makes sure the sortable form of the callnumber is calculated correctly. - Go to inventory - Search for your items - Before patch, they should sort on callnumber as above, after the patch the correct sort order should be: B29 .C55 2008 B29 .L24 1983 B29 .L264 1998 B29 .P666 2004 B 29 V55 1998 Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA CC| |martin.renvoize@ptfs-europe | |.com --- Comment #8 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Works as expected, Passing QA -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25897 --- Comment #9 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Pushed to master for 20.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.