From a1243bd7b5e5a7ead0f1b849a2deaa8651f9b9bd Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 29 Oct 2014 17:09:26 -0400 Subject: [PATCH] Holding_maintenance - SQL update to exclude deleted volumes Cross-port: b1b43f2 --- KCLS/sql/HoldingsMaintenance/holdings_maintenance.SQL | 1 + 1 file changed, 1 insertion(+) diff --git a/KCLS/sql/HoldingsMaintenance/holdings_maintenance.SQL b/KCLS/sql/HoldingsMaintenance/holdings_maintenance.SQL index 5968ac5d08..6e1d324809 100644 --- a/KCLS/sql/HoldingsMaintenance/holdings_maintenance.SQL +++ b/KCLS/sql/HoldingsMaintenance/holdings_maintenance.SQL @@ -77,6 +77,7 @@ SELECT acn.create_date, acn.creator, acn.deleted, acn.edit_date, acn.editor, acn LEFT OUTER JOIN asset.copy AS acp ON acn.id = acp.call_number WHERE acn.record = tcn_value + AND acn.deleted = 'f' AND acp.id IS NULL -- 2.11.0