Attachment 107701 Details for Bug 21946 – Bug 21946: (follow-up) Restore join to biblioitems

[patch] Bug 21946: (follow-up) Restore join to biblioitems

Bug-21946-follow-up-Restore-join-to-biblioitems.patch (text/plain), 1.05 KB, created by Nick Clemens (kidclamp) on 2020-08-03 12:27:41 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2020-08-03 12:27:41 UTC

Size: 1.05 KB

patch

obsolete

>From 2fb5db1215d965877e3376541baf5beda097049a Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Mon, 3 Aug 2020 12:27:15 +0000
>Subject: [PATCH] Bug 21946: (follow-up) Restore join to biblioitems
>
>---
> C4/Circulation.pm | 3 ++-
> 1 file changed, 2 insertions(+), 1 deletion(-)
>
>diff --git a/C4/Circulation.pm b/C4/Circulation.pm
>index 07f81baeca..dfbe1eeb27 100644
>--- a/C4/Circulation.pm
>+++ b/C4/Circulation.pm
>@@ -461,7 +461,8 @@ sub TooMany {
>             if (C4::Context->preference('item-level_itypes')) {
>                 $count_query .= " WHERE items.itype NOT IN ( $issuing_itemtypes_query )";
>             } else {
>-                $count_query .= " WHERE biblioitems.itemtype NOT IN ( $issuing_itemtypes_query )";
>+                $count_query .= " JOIN biblioitems USING (biblionumber)
>+                                  WHERE biblioitems.itemtype NOT IN ( $issuing_itemtypes_query )";
>             }
>             push @bind_params, $maxissueqty_rule->branchcode;
>             push @bind_params, $maxissueqty_rule->categorycode;
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21946: 87713 | 87714 | 87715 | 87716 | 87717 | 87718 | 87719 | 88392 | 88574 | 88575 | 88576 | 88577 | 88578 | 88579 | 88580 | 88581 | 88926 | 88927 | 88928 | 88929 | 88930 | 88931 | 88932 | 88933 | 88934 | 89167 | 89168 | 89169 | 89170 | 89171 | 89172 | 89173 | 89174 | 89175 | 89176 | 93075 | 93076 | 93077 | 93078 | 93079 | 93080 | 93081 | 93082 | 93083 | 93084 | 93086 | 93087 | 93088 | 93089 | 93090 | 93091 | 93092 | 93093 | 93094 | 93095 | 93096 | 93097 | 93098 | 93099 | 93100 | 93101 | 93102 | 93103 | 93104 | 93105 | 96977 | 96978 | 96979 | 96980 | 96981 | 96982 | 96983 | 96984 | 96985 | 96986 | 96987 | 99419 | 99420 | 99421 | 99422 | 99423 | 99424 | 107035 | 107036 | 107037 | 107038 | 107039 | 107040 | 107041 | 107278 | 107279 | 107280 | 107281 | 107282 | 107283 | 107284 | 107467 | 107489 | 107686 | 107687 | 107688 | 107689 | 107690 | 107691 | 107692 | 107693 | 107694 | 107701 | 107733