Bugzilla – Attachment 105821 Details for
Bug 25726
Holds to Pull made empty by pathological holds
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 25726: make holds to pull ignore holds where found is not null and itemnumber is null
Bug-25726-make-holds-to-pull-ignore-holds-where-fo.patch (text/plain), 1.38 KB, created by
ByWater Sandboxes
on 2020-06-12 14:23:18 UTC
(
hide
)
Description:
Bug 25726: make holds to pull ignore holds where found is not null and itemnumber is null
Filename:
MIME Type:
Creator:
ByWater Sandboxes
Created:
2020-06-12 14:23:18 UTC
Size:
1.38 KB
patch
obsolete
>From cc42336aaad0910e7996f4db4a732671d0d5ec7a Mon Sep 17 00:00:00 2001 >From: Andrew Fuerste-Henry <andrew@bywatersolutions.com> >Date: Fri, 12 Jun 2020 13:51:16 +0000 >Subject: [PATCH] Bug 25726: make holds to pull ignore holds where found is not > null and itemnumber is null > >To test: >1- place 2 bib-level holds on available items >2- confirm they both show on Holds to Pull >3- edit one hold from the database to set found='T' >4- reload Holds to Pull, confirm it is now empty >5- apply patch >6- Reload Holds to Pull >7- confirm it now shows the hold you did not edit > >Signed-off-by: donnab <donna@bywatersolutions.com> >--- > circ/pendingreserves.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl >index 7f2062942a..b95d92ef41 100755 >--- a/circ/pendingreserves.pl >+++ b/circ/pendingreserves.pl >@@ -223,7 +223,7 @@ my $strsth = > $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 IS NOT NULL) >+ AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL AND itemnumber IS NOT NULL) > AND issues.itemnumber IS NULL > AND reserves.priority <> 0 > AND reserves.suspend = 0 >-- >2.11.0
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 25726
:
105800
|
105821
|
106493