Comment 2 for bug 1712922

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.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;