is it possible to move reviews from one user that needs to be deleted to another user that will remain as an active user?

is it possible to move reviews from one user that needs to be deleted to another user that will remain as an active user?

Im trying to clean up users inorder to create a new one and I have 2 users id like to delete but they have reviews I need to keep. Is there a way to move those reviews to another user?

1 answer

1 accepted

Hi Seth,

It's possible but you will have to modify the database directly:

  • generate a backup of the Crucible instance (in Admin/Backup)
  • stop Crucible
  • find the primary key of the user you want to delete:
select cru_user_id from cru_user where cru_user_name = 'user_to_delete'

  • find the primary key of the user you want to keep:
select cru_user_id from cru_user where cru_user_name = 'user_to_keep'

  • update all the reviews, review comments and review participants to switch them from the old user to the other one:
update cru_comment set cru_user_id = 'id_user_to_keep' where cru_user_id = 'id_user_to_delete';
update cru_comment_read_status set cru_user = 'id_user_to_keep' where cru_user = 'id_user_to_delete';
update cru_review_participant set cru_user = 'id_user_to_keep' where cru_user = 'id_user_to_delete';
update cru_review set cru_creator = 'id_user_to_keep' where cru_creator = 'id_user_to_delete';
  • start Crucible
  • in the Admin, if the user to delete is a moderator, default reviewer and default review participant in any project, remove him or her from the project's setting (using the button 'Edit' in the 'Crucible settings' column for each project)

You may also want to update the review history:

see the cru_logitem table, the cru_user_id column

 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published 14 hours ago in Off-topic

Get to know our Atlassian User Group Leaders from Bengaluru, India

Meet @Dinesh Dhinakaran, @Vishnu Vasudeva, @Rajeev Verma, and Jamshid Nalakath: Our extraordinary AUG leaders from Bengaluru, India. These four work together to strengthen the bonds of their local co...

102 views 0 4
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you