https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Small patch Status|NEW |Needs Signoff -- 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=19915 --- Comment #2 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 70275 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=70275&action=edit Bug 19915 - Use cn_sort values for getting inventory items To test: 1 - Catalog an item under LCC with callnumber GT95 2 - cn_sort should calculate as GT0095 3 - Go to inventory tool 4 - Enter a range that should have your item e.g LC GT90 to GT100 5 - Item is not returned 6 - Apply patch 7 - Item should be returned 8 - Verify things otherwise work as expected -- 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=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |barton@bywatersolutions.com --- Comment #3 from Nick Clemens <nick@bywatersolutions.com> --- *** Bug 14983 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA CC| |m.de.rooy@rijksmuseum.nl --- Comment #4 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- +my $schema = Koha::Database->new()->schema(); +my @class_sources = $schema->resultset('ClassSource')->search(); Koha::Object ? -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #6 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 70339 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=70339&action=edit Bug 19915 - Use cn_sort values for getting inventory items To test: 1 - Catalog an item under LCC with callnumber GT95 2 - cn_sort should calculate as GT0095 3 - Go to inventory tool 4 - Enter a range that should have your item e.g LC GT90 to GT100 5 - Item is not returned 6 - Apply patch 7 - Item should be returned 8 - Verify things otherwise work as expected -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 abernaud <anne-claire.bernaudin@univ-rennes1.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |anne-claire.bernaudin@univ- | |rennes1.fr Status|Needs Signoff |Patch doesn't apply --- Comment #7 from abernaud <anne-claire.bernaudin@univ-rennes1.fr> --- After applying the patch, at http://pro.user10-koha.sandbox.biblibre.eu/cgi-bin/koha/tools/inventory.pl I get the following error message : Software error: Can't locate Koha/ClassificationSources.pm in @INC (you may need to install the Koha::ClassificationSources module) (@INC contains: /home/koha/src /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.22.1 /usr/local/share/perl/5.22.1 /usr/lib/x86_64-linux-gnu/perl5/5.22 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.22 /usr/share/perl/5.22 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base .) at /home/koha/src/tools/inventory.pl line 42. BEGIN failed--compilation aborted at /home/koha/src/tools/inventory.pl line 42. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #70338|0 |1 is obsolete| | Attachment #70339|0 |1 is obsolete| | --- Comment #8 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 72950 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72950&action=edit Bug 19915 - Unit test prove -v t/db_dependent/Items/GetItemsForInventory.t -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #10 from Nick Clemens <nick@bywatersolutions.com> --- Did you make sure to apply the dependencies -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff --- Comment #12 from Nick Clemens <nick@bywatersolutions.com> --- The test plan here uses numbers valid for LC callnumbers. I think you will need to find a valid callnumber range if using a different classification source -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 sandboxes@biblibre.com <sandboxes@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |sandboxes@biblibre.com Status|Needs Signoff |Signed Off --- Comment #14 from sandboxes@biblibre.com <sandboxes@biblibre.com> --- Patch tested with a sandbox, by Anne-Claire Bernaudin <anne-claire.bernaudin@univ-rennes1.fr> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 sandboxes@biblibre.com <sandboxes@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #72951|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #16 from sandboxes@biblibre.com <sandboxes@biblibre.com> --- Created attachment 72989 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72989&action=edit Bug 19915 - Use cn_sort values for getting inventory items To test: 1 - Catalog an item under LCC with callnumber GT95 2 - cn_sort should calculate as GT0095 3 - Go to inventory tool 4 - Enter a range that should have your item e.g LC GT90 to GT100 5 - Item is not returned 6 - Apply patch 7 - Item should be returned 8 - Verify things otherwise work as expected Signed-off-by: Anne-Claire Bernaudin <anne-claire.bernaudin@univ-rennes1.fr> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Bug 19915 depends on bug 19929, which changed state. Bug 19929 Summary: Add Koha Objects for class_source and class_sort_rules https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19929 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #18 from Nick Clemens <nick@bywatersolutions.com> --- (In reply to Katrin Fischer from comment #17)

Hi Nick,

I am a little confused about the need for the new classification source pull down on the inventory form. Some questions:

1) Why is it needed? We need to know which source to use for converting the callnumbers entered, currently we test against unconverted callnumbers which doesn't work for manyschemes, the reanges won't be returned correctly

2) Should we not only show the classification sources marked as 'in use'?

Good idea, I will followup

3) Why can't I unset it?

Even when cn_source is not set for an item it uses the default, unsetting it shouldn't be necessary

4) Is it supposed to limit the search? Because when I select LOC classification, items are found, although they don't have a classification source set.

It doesn't limit the search per se, it just converts the range to the correct values for cn_sort -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #19 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 76120 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=76120&action=edit Bug 19915: Only show class sources in use -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact|testopia@bugs.koha-communit |m.de.rooy@rijksmuseum.nl |y.org | -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #22 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 76722 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=76722&action=edit Bug 19915: (QA follow-up) Tidy up GetItemsForInventory.t Standard edits like modules, schema, Koha objects instead of DBIC. Removing unneeded autoflush. Moving initial test to a first subtest. No need to clear issues if you clear items. Adding a FIXME for OldWay; would be nice to remove that code.. Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #76120|0 |1 is obsolete| | --- Comment #24 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 76724 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=76724&action=edit Bug 19915: Only show class sources in use Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #26 from Eric Phetteplace <ephetteplace@cca.edu> --- (In reply to Marcel de Rooy from comment #25)

No blocker for me, but adding an option to control the switch from callnumber to cn_sort might be handy for some people?

What is the use case for sorting by callnumber? I cannot think of a reason one would want to sort by a non-normalized call number. Especially for inventory purposes, having a sort that supposedly matches your shelves is the only useful one, unless I'm missing something. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Failed QA --- Comment #28 from Nick Clemens <nick@bywatersolutions.com> --- I talked with enough people to agree this must be optional - will provide a followup -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #29 from David Cook <dcook@prosentient.com.au> --- I am so confused by this bug. Isn't the inventory already sorting by call number? -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #31 from David Cook <dcook@prosentient.com.au> --- (In reply to Carl from comment #30)

Yes, it's sorted by call number but that does not sort correctly. It should be sorted by items.cn_sort which will sort correctly.

I am certain that I just looked at this a couple months ago and it was using the normalized call numbers. I had an issue where the normalized call numbers were wrong for old records, but after re-generating the values, all was well. Let me see if I can find any details on that issue I had... -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #33 from David Cook <dcook@prosentient.com.au> --- (In reply to David Cook from comment #32)

Here we go...

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21447

I wish that I had written that bug report better. In hindsight, I think maybe #19915 fixes the underlying problem that I observed, which means that both the list view and export views should be fixed after these changes... -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #72989|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #76721|0 |1 is obsolete| | Attachment #76722|0 |1 is obsolete| | Attachment #76723|0 |1 is obsolete| | Attachment #76724|0 |1 is obsolete| | --- Comment #34 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 81816 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81816&action=edit Bug 19915: Add unit test to GetItemsForInventory.t prove -v t/db_dependent/Items/GetItemsForInventory.t Signed-off-by: Anne-Claire Bernaudin <anne-claire.bernaudin@univ-rennes1.fr> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> Moved the betwen typo edit back here. Current patch-complexity: Small patch -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #36 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 81818 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81818&action=edit Bug 19915: Use cn_sort values for getting inventory items To test: 1 - Catalog an item under LCC with callnumber GT95 2 - cn_sort should calculate as GT0095 3 - Go to inventory tool 4 - Enter a range that should have your item e.g LC GT90 to GT100 5 - Item is not returned 6 - Apply patch 7 - Item should be returned 8 - Verify things otherwise work as expected Signed-off-by: Anne-Claire Bernaudin <anne-claire.bernaudin@univ-rennes1.fr> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #38 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 81820 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81820&action=edit Bug 19915: Don't delete in tests -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=21629 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #41 from Nick Clemens <nick@bywatersolutions.com> --- (In reply to Martin Renvoize from comment #40)

In bug 21629 we corrected a similar case where we changed from callnumber to cn_sort sorting, but we did not require a system preference to enable/disable that change.

I personally don't feel we should require the system preference here either.. or at least we should be consistent elsewhere if we are going to introduce such a preference...

Can we push this back to the mailing list for comment?

I think the concern was some migrations where the cn_sort may not be populated or not populated correctly. I am fine either way (would prefer without the switch, it would highlight data that should be fixed) I will email the lists. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |Signed Off -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #44 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 83645 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83645&action=edit Bug 19915: (QA follow-up) Tidy up GetItemsForInventory.t Standard edits like modules, schema, Koha objects instead of DBIC. Removing unneeded autoflush. Moving initial test to a first subtest. No need to clear issues if you clear items. Adding a FIXME for OldWay; would be nice to remove that code.. Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> https://bugs.koha-community.org/show_bug.cgi?id=19905 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #46 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 83647 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83647&action=edit Bug 19915: Only show class sources in use Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> https://bugs.koha-community.org/show_bug.cgi?id=19905 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #48 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 83649 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83649&action=edit Bug 19915: (follow-up) Fix test count from rebase https://bugs.koha-community.org/show_bug.cgi?id=19905 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=22263 --- Comment #50 from Katrin Fischer <katrin.fischer@bsz-bw.de> ---

...

It might be nice to add a script to help people populating this field if it was somehow missed during migration or set to a wrong value, but that is out of scope here for sure!

Thank you, file a bug and we can look at a future time :-)

Done: bug 22263 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #83644|0 |1 is obsolete| | --- Comment #51 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 84665 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=84665&action=edit Bug 19915: Add unit test to GetItemsForInventory.t prove -v t/db_dependent/Items/GetItemsForInventory.t Signed-off-by: Anne-Claire Bernaudin <anne-claire.bernaudin@univ-rennes1.fr> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> Moved the betwen typo edit back here. https://bugs.koha-community.org/show_bug.cgi?id=19905 Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #83646|0 |1 is obsolete| | --- Comment #53 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 84667 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=84667&action=edit Bug 19915: Use cn_sort values for getting inventory items To test: 1 - Catalog an item under LCC with callnumber GT95 2 - cn_sort should calculate as GT0095 3 - Go to inventory tool 4 - Enter a range that should have your item e.g LC GT90 to GT100 5 - Item is not returned 6 - Apply patch 7 - Item should be returned 8 - Verify things otherwise work as expected Signed-off-by: Anne-Claire Bernaudin <anne-claire.bernaudin@univ-rennes1.fr> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> https://bugs.koha-community.org/show_bug.cgi?id=19905 Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #83648|0 |1 is obsolete| | --- Comment #55 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 84669 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=84669&action=edit Bug 19915: Don't delete in tests https://bugs.koha-community.org/show_bug.cgi?id=19905 Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master --- Comment #57 from Nick Clemens <nick@bywatersolutions.com> --- Awesome work all! Pushed to master for 19.05 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |Pushed to Stable --- Comment #58 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Pushed to 18.11.x for 18.11.03 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 --- Comment #60 from Eric Phetteplace <ephetteplace@cca.edu> --- Perhaps this is a problem with cn_sort itself or something else but I've noticed that our inventory _still_ doesn't sort correctly. Here is an example for one of our locations with call numbers B0 - B30: - B 29 V55 1998 - B29 .C55 2008 - B29 .L24 1983 - B29 .L264 1998 - B29 .P666 2004 I've had a JS hack in place, originally for addressing this bug, but I've never been able to remove it because of problems like the above. This is the correct sort after the hack is applied: - B29 .C55 2008 - B29 .L24 1983 - B29 .L264 1998 - B29 .P666 2004 - B 29 V55 1998 It's also what I see if I run a query like SELECT itemnumber, cn_sort, itemcallnumber FROM items WHERE homebranch = 'OAK' AND items.itemcallnumber LIKE 'B29%' OR items.itemcallnumber LIKE 'B%29%' OR items.itemcallnumber LIKE ' B29%' OR items.itemcallnumber LIKE ' B%29%' ORDER BY cn_sort itemnumber cn_sort itemcallnumber 72613 B0029 C55 02008 B29 .C55 2008 59337 B0029 L24 01983 B29 .L24 1983 69756 B0029 L264 01998 B29 .L264 1998 65867 B0029 P666 02004 B29 .P666 2004 40918 B0029 V55 01998 B 29 V55 1998 Why is my report sorted correctly, but not the inventory page? It leads me to believe that the inventory page isn't really sorting by cn_sort. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19915 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|release-notes-needed | -- You are receiving this mail because: You are watching all bug changes.