[Koha-bugs] [Bug 35997] Cancelling a hold should remove the hold from the queue

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Feb 19 05:02:09 CET 2024


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

Victor Grousset/tuxayo <victor at tuxayo.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |victor at tuxayo.net

--- Comment #5 from Victor Grousset/tuxayo <victor at tuxayo.net> ---
Is the join on borrowernumber, biblionumber[1], item_level_request,
holdingbranch[1] needed?
`itemnumber` is not the primary key of tmp_holdsqueue so is it possible that
twice the same itemnumber would be in the table?

Even with 5 record level holds for the same patron on a record that has 4 item
there is no duplication of itemnumber tmp_holdsqueue.

Neither with multiple item level holds on the same item for different patrons.

[1] these are 100% sure to be redundant. itemnumber implies biblionumber and
holdingbranch

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


More information about the Koha-bugs mailing list