Bugzilla – Attachment 16589 Details for
Bug 9786
[3.8.X] Holds to pull showing items not available
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 9786 - Holds to pull showing items not available
Bug-9786---Holds-to-pull-showing-items-not-availab.patch (text/plain), 1.53 KB, created by
Marcel de Rooy
on 2013-03-21 09:48:15 UTC
(
hide
)
Description:
Bug 9786 - Holds to pull showing items not available
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2013-03-21 09:48:15 UTC
Size:
1.53 KB
patch
obsolete
>From fef26bfdf6fd62db7534be7459d2b29c7de049d2 Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?=E2=80=9CByWater?= <âstaff@bywatersolutions.comâ> >Date: Mon, 11 Mar 2013 09:12:33 -0400 >Subject: [PATCH] Bug 9786 - Holds to pull showing items not available >Content-Type: text/plain; charset="utf-8" > >If an item is on hold and waiting for pickup, and another >hold is placed on the record, a hold to pull will show in the >Holds to pull report, even though there are no items that can >fill that hold request. > >Test Plan: >1) Create a record with 1 item >2) Create 2 holds on the record >3) Fill the first hold >4) Check the Holds to pull report, it should show this record >5) Apply patch >6) Reload the Holds to pull report, it should no longer show this record > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > circ/pendingreserves.pl | 2 +- > 1 files changed, 1 insertions(+), 1 deletions(-) > >diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl >index edc8abe..f8fcda5 100755 >--- a/circ/pendingreserves.pl >+++ b/circ/pendingreserves.pl >@@ -140,7 +140,7 @@ if ( $run_report ) { > $sqldatewhere > AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) > AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL) >- AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found='W') >+ AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL) > AND issues.itemnumber IS NULL > AND reserves.priority <> 0 > AND reserves.suspend = 0 >-- >1.7.7.6
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 9786
:
16066
|
16088
| 16589