[Koha-bugs] [Bug 21447] Inventory lists incorrectly sorted

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

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

--- Comment #2 from David Cook <dcook at prosentient.com.au> ---
(In reply to Katrin Fischer from comment #1)
> Maybe the name of this bug should then be "Add a script to update cn_sort"?
> This is a data problem and not a problem of the sorting itself.
> 

Yeah that could be a good idea. I guess I'm not sure at this point why the
cn_sort values became inconsistent, so looking for ideas. Although based on
what you said on IRC, I'm thinking maybe it's an issue with an external
dependency? 

If it is an external dependency, maybe I can trace in what version it changed
and then base the update around that?

> touch_items is rather costly/time consuming, we recently fixed it using a
> little script creating SQL statements for the updates.

You mean you created a little script for updating cn_sort? I hadn't thought of
doing the update directly like that. That's a good idea. I don't suppose we use
the cn_sort value in any indexes?

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