In the Team table in a project, the same person can be added more than once to the same project. Since multiple roles can be added to the same team member, there isn't a use case for adding the same person more than once.

We have 5 projects currently with duplicate people in the database (query below), and we can leave that data alone. This update would prevent this from happening more in the future. It is possible that these projects were created before we had enabled one person to have many roles or had entry error.

In Scope

• Update the inline form to only show dropdown options that include team members not yet added to the team

Not in scope

• Cleaning up existing data since there are only a handful of projects with duplicate personnel

SQL

SELECT
    project_id,
    user_id,
    COUNT(*) as duplicate_count
FROM
    moped_proj_personnel
WHERE is_deleted = FALSE   
GROUP BY
    project_id,
    user_id
HAVING
    COUNT(*) > 1;