We're updating the issue view to help you get more done. 

AMNH script: remove duplicate values for ca_entities.role

Description

I think because values are imported into ca_entities.role from different mappings, it's causing duplicate values to occur. See examples in search results by searching on "*":

http://amnhdemo.whirl-i-gig.com:8084/index.php/find/SearchEntities/Index

The issue was not solved with this fix, which I thought might do the trick:

https://collectiveaccess.atlassian.net/browse/PROV-2870?atlOrigin=eyJpIjoiZDQ5MGY1MGM4MDIxNDg3YjkzNjNiNGU0OThkYmQ3NmQiLCJwIjoiaiJ9

Environment

None

Activity

Show:
Seth Kaufman
June 11, 2020, 4:12 AM

Added removeDupeEntityRoles.php script in /data/amnhdemo/support/scripts and Git

Assignee

Seth

Reporter

Eve Perry

Labels

Priority

Major
Configure