Community
Q&A
Jira
Questions
Inconsistent values in database - jiraissue table

Inconsistent values in database - jiraissue table

In my jiraissue table, the value for jiraissue.assignee relates to the username value in cwd_user.user_name for all users except one. For this one user, the value of jiraissue.assignee relates to the cwd_user.id value for all issues assigned to this user.

Has anyone encountered this issue before? My guess is that this is somehow related to how the user was created.

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

Depending on your JIRA version jiraissue.assignee refers to app_user.user_key and not to cwd_user.lower_user_name.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thank you for your answer. We determined the difference in the assignee value was caused by an upgrade.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Inconsistent values in database - jiraissue table

1 answer

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events