From d5dff1b25ecdafadd832f5012c7566e13c80a09e Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Wed, 7 Oct 2020 08:31:56 +0100
Subject: [PATCH] Bug 24446: Add datecancelled handling to GetTransfers
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Signed-off-by: Kathleen Milne <kathleen.milne@cne-siar.gov.uk>
Signed-off-by: Joonas Kylmälä <joonas.kylmala@helsinki.fi>
---
 C4/Circulation.pm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/C4/Circulation.pm b/C4/Circulation.pm
index ca0f13dca3..7b119e169d 100644
--- a/C4/Circulation.pm
+++ b/C4/Circulation.pm
@@ -3437,6 +3437,7 @@ sub GetTransfers {
         FROM branchtransfers
         WHERE itemnumber = ?
           AND datearrived IS NULL
+          AND datecancelled IS NULL
         ';
     my $sth = $dbh->prepare($query);
     $sth->execute($itemnumber);
-- 
2.20.1