Since I couldn't find any other way to change the author of the comments.
I'd like to figure out how we can do that in database.
Why? - Duplicate username issues with multiple domain alias.
So we are looking to change all comments that has x@abc.com(internal user) to x (external user)
We have a solution going forward, but we'd like to clean up the existing data.
I hope someone can help.
Tried so far:
Haven't tried:
Edit 1:
I found the weirdest thing in db.
Looking at a comment, the author on the comment does not match what's in jiraaction.
To make sure I was on same row in DB, I even tried updating the comment in the UI, and it did change the actionbody and updateAuthor.
Now I am just lost :|
Hi @zunairf
if your confident with SQL and the Jira database you could try some of the tricks in this article.
https://community.atlassian.com/t5/Migrations-articles/Jira-LDAP-Migration-using-SQL/ba-p/942752
https://community.atlassian.com/t5/Jira-questions/Change-user/qaq-p/1265684
Tom
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.