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

(-)a/circ/pendingreserves.pl (-3 / +2 lines)
Lines 224-230 my $strsth = Link Here
224
    $sqldatewhere
224
    $sqldatewhere
225
    AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
225
    AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
226
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
226
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
227
    AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL)
227
    AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL AND itemnumber IS NOT NULL)
228
    AND issues.itemnumber IS NULL
228
    AND issues.itemnumber IS NULL
229
    AND reserves.priority <> 0 
229
    AND reserves.priority <> 0 
230
    AND reserves.suspend = 0
230
    AND reserves.suspend = 0
Lines 233-239 my $strsth = Link Here
233
    ";
233
    ";
234
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
234
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
235
    #    multiple patrons have a hold on an item
235
    #    multiple patrons have a hold on an item
236
236
#FIXME "found IS NOT NULL AND itemnumber IS NOT NULL" is just a workaround: see BZ 25726
237
237
238
if (C4::Context->preference('IndependentBranches')){
238
if (C4::Context->preference('IndependentBranches')){
239
    $strsth .= " AND items.holdingbranch=? ";
239
    $strsth .= " AND items.holdingbranch=? ";
240
- 

Return to bug 25726