From f10de92a70e1f9ec99130399a964722ac0c7843f Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Thu, 24 Aug 2017 17:34:02 -0400 Subject: [PATCH] LP1712922: Exclude Deleted ACPL in Vol/Copy Editor Just what it says on the tin. When loading the list of ACPL in the editor only retrieve the non-deleted locations. Tester's note: there's no database contraint that strictly prevents a copy from linking to a deleted location, so for items like that, the copy location selector will be blank. This is an uncommon situation, but Evergreen admins can identify such items by running the following query: select acp.id, acp.barcode, acpl.name from asset.copy acp join asset.copy_location acpl on (acpl.id = acp.location) where not acp.deleted and acpl.deleted order by acp.id; Signed-off-by: Jason Boyer Signed-off-by: Galen Charlton --- Open-ILS/web/js/ui/default/staff/cat/volcopy/app.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/web/js/ui/default/staff/cat/volcopy/app.js b/Open-ILS/web/js/ui/default/staff/cat/volcopy/app.js index 8399f72923..19596b9c9c 100644 --- a/Open-ILS/web/js/ui/default/staff/cat/volcopy/app.js +++ b/Open-ILS/web/js/ui/default/staff/cat/volcopy/app.js @@ -138,7 +138,7 @@ function(egCore , $q) { service.get_locations = function(orgs) { return egCore.pcrud.search('acpl', - {owning_lib : orgs}, + {owning_lib : orgs, deleted : 'f'}, {order_by : { acpl : 'name' }}, {atomic : true} ); }; -- 2.43.2