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?
It's possible but you will have to modify the database directly:
select cru_user_id from cru_user where cru_user_name = 'user_to_delete'
select cru_user_id from cru_user where cru_user_name = 'user_to_keep'
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';
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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...
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