]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP1712922: Exclude Deleted ACPL in Vol/Copy Editor
authorJason Boyer <jboyer@library.in.gov>
Thu, 24 Aug 2017 21:34:02 +0000 (17:34 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Fri, 25 Aug 2017 15:02:33 +0000 (11:02 -0400)
commit81b26198f1ad2c79c0cb872c05892dc1f3ce0030
tree8b12e074989284dce19d0d93da411a681ecdc912
parent1757f32c67f1ce32368d40c451a6cfbcd0bb0c6b
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 <jboyer@library.in.gov>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/web/js/ui/default/staff/cat/volcopy/app.js