]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1482757: Remove 'orphaned_uri_list' and 'NOT cn.deleted' criteria
authorMichele Morgan <mmorgan@noblenet.org>
Fri, 24 Apr 2020 16:43:39 +0000 (12:43 -0400)
committerMichele Morgan <mmorgan@noblenet.org>
Fri, 25 Feb 2022 21:00:43 +0000 (16:00 -0500)
commit84d192276c2cc3346cf179d6d1a9ed46ba508478
treef606c03d05ea2d60ef88f3e915817aea23c6c1c3
parent7385218078aaaa6a96b306fe508fa7e34eb66b95
LP#1482757: Remove 'orphaned_uri_list' and 'NOT cn.deleted' criteria

Per Dan Wells' suggestions.

1) One possible "crack" I see for data to fall through is the dead map
selector. The "AND cn.label = '##URI##' AND NOT cn.deleted" seems overly
restrictive. Now, I realize we *shouldn't* have mappings to deleted or
non-##URI## call numbers, but it isn't impossible, and I don't think we'd
have harm in leaving those restrictions out. If a map isn't used, let's
get rid of it regardless, I think.

2) (side note) orphaned_uri_list doesn't seems to be used any more, so
should be removed.

Signed-off-by: Michele Morgan <mmorgan@noblenet.org>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Michele Morgan <mmorgan@noblenet.org>
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.biblio.extract_located_uris.sql