Comment 2 for bug 1712922

Revision history for this message
Galen Charlton (gmc) wrote :

Tested and pushed to master and rel_2_12. Thanks, Jason!

Note that 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.barcode,
    from asset.copy acp
    join asset.copy_location acpl on ( = acp.location)
    where not acp.deleted
    and acpl.deleted
    order by;