https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25726
--- Comment #5 from Katrin Fischer <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
