[Koha-bugs] [Bug 25726] Holds to Pull made empty by pathological holds

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

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

--- Comment #5 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Hi Andrew,

I am actually a bit confused by the SQL change and worried about unwanted side
effects:

-    AND items.itemnumber NOT IN (select itemnumber FROM reserves where found
IS NOT NULL)
+    AND items.itemnumber NOT IN (select itemnumber FROM reserves where found
IS NOT NULL AND itemnumber IS NOT NULL)

If I understand correctly this will make the items in 'Transit' status show up
in the list. But if they really are in transit - they can't be pulled... so
should they show up? I think the logic of the SQL might be right and we need to
take care to fix the holds, if the state of found = "T" and itemnumber empty is
unwanted.

I've tried several things to get a 'pathological' hold, but haven't succeded
other than in turning up more oddities (see bug 25748).

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