View | Details | Raw Unified | Return to bug 4870
Collapse All | Expand All

(-)a/misc/cronjobs/holds/build_holds_queue.pl (-3 / +3 lines)
Lines 168-175 sub GetItemsAvailableToFillHoldRequestsForBib { Link Here
168
    $items_query .=   "WHERE items.notforloan = 0
168
    $items_query .=   "WHERE items.notforloan = 0
169
                       AND holdingbranch IS NOT NULL
169
                       AND holdingbranch IS NOT NULL
170
                       AND itemlost = 0
170
                       AND itemlost = 0
171
                       AND wthdrawn = 0
171
                       AND wthdrawn = 0";
172
                       AND items.onloan IS NULL
172
    $items_query .=   " AND damaged = 0 " unless C4::Context->preference('AllowHoldsOnDamagedItems');
173
    $items_query .=   " AND items.onloan IS NULL
173
                       AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0)
174
                       AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0)
174
                       AND itemnumber NOT IN (
175
                       AND itemnumber NOT IN (
175
                           SELECT itemnumber
176
                           SELECT itemnumber
176
- 

Return to bug 4870