Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

How to transfer ownership of shared query folders?

Currently, a user is not allowed to edit the queries that are shared with him/her. It is not possible to transfer the ownership of the query folder to another user from the user interface. However, this can be achieved by executing the following SQLs.

For example, the ownership of the query folder 'Admin queries' needs to be transferred from the user 'Neha' to 'Shraddha'. Listed below are the commands that need to use.

select identifier  from catissue_user where login_name = 'neha';
# Output: 23

select identifier  from catissue_user where login_name = 'shraddha';
# Output: 24

update catissue_query_folders set owner = 24 where name in ('Admin queries');
# you can add more folder names to the IN clause separated by a comma.
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com