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';
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot