I have the following problem when renaming a username for an existing user.
I have created a new user, for instance username 'firstname.lastname@example.org' and email also 'email@example.com'.
After that I created issues where this user firstname.lastname@example.org is the ASSIGNEE.
Then I renamed the username from 'email@example.com' to tUlrich.
The table in SQL Server database dbo.cwd_user is showing the correct value in the field user_name: tUlrich
The problem now is, that the user is renamed correctly, but new and existing issue still have the first username 'firstname.lastname@example.org' in a user field, for instance ASSIGNEE in the table jiraissue.
The table dbo.jiraissue still has the wrong value in the field ASSIGNEE: email@example.com.
My question now is, how can I correct this field (reference) in dbo.jiraissue?
You are not expected to be able to change this field in the jiraissue table. Actually the value in the jiraissues table is correct. I understand why you might believe it to be wrong, but that is because of the way Jira is tracking user account renames.
Jira tracks a user account being renamed inside the app_user table. When an account is first created in Jira the user_key field is set to match the cwd_user.user_name value. However after this account is first created, that user_key field is never expected to change in the Jira database. Regardless of whether or not the username changes, that user_key remains constant for that particular user account. Instead the app_user.lower_user_name value can change to correspond with the changes in cwd_user table when the user gets renamed, but there are several places within Jira that do not directly refer to the cwd_user table for the user account. Instead Jira is primarily looking at the app_user.user_key entry for historical records such as which user updated an issue, or executed a transition. This can also be seen when you look at the issue details view in Jira, if you click on the history tab, this view shows the app_user.user_key field for a username, and not the cwd_user.user_name field.
This way Jira can keep track of historical changes that take place through a specific account, even if that account's name changes over time.
As such I would not recommend trying to change this value in the database, but rather, it is better to refer to the app_user table to understand which account is really being used here.
Does this help?
If not, please let me know more about what exactly you are trying to achieve through SQL and perhaps I can offer another solution here.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs