Connector Improvement: teamName and roleName, which are not added in the user_team table
The data coming under the teams attribute from the user endpoint also has fields as teamName and roleName, which are not added in the user_team
table, causing confusion for the user to fetch what roleID is attached to roleName
-
Official comment
Rajeswaran,
Thank you for reaching out - can you please clarify which source you are referring to?
Thank you!
-
Hi This is for the JIRA_ALIGN connector
-
Hi Rajeswaran,
Thank you for reaching out.
After analysis, we observed that the USER_TEAM table includes the fields role_id and team_id, which are linked to the TEAM and ROLE tables through a foreign key relationship. The associated role and team names can be identified within these respective tables. Adding the role and team names directly to the USER_TEAM table would result in data redundancy, so we have decided to proceed with this approach to maintain data integrity.
Please sign in to leave a comment.
Comments
3 comments