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

(-)a/C4/HoldsQueue.pm (-2 / +4 lines)
Lines 222-228 sub GetBibsWithPendingHoldRequests { Link Here
222
                     FROM reserves
222
                     FROM reserves
223
                     WHERE found IS NULL
223
                     WHERE found IS NULL
224
                     AND priority > 0
224
                     AND priority > 0
225
                     AND reservedate <= CURRENT_DATE()";
225
                     AND reservedate <= CURRENT_DATE()
226
                     AND suspend = 0
227
                     ";
226
    my $sth = $dbh->prepare($bib_query);
228
    my $sth = $dbh->prepare($bib_query);
227
229
228
    $sth->execute();
230
    $sth->execute();
Lines 265-270 sub GetPendingHoldRequestsForBib { Link Here
265
                         AND found IS NULL
267
                         AND found IS NULL
266
                         AND priority > 0
268
                         AND priority > 0
267
                         AND reservedate <= CURRENT_DATE()
269
                         AND reservedate <= CURRENT_DATE()
270
                         AND suspend = 0
268
                         ORDER BY priority";
271
                         ORDER BY priority";
269
    my $sth = $dbh->prepare($request_query);
272
    my $sth = $dbh->prepare($request_query);
270
    $sth->execute($biblionumber);
273
    $sth->execute($biblionumber);
271
- 

Return to bug 8419