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 other 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 useduse.
| Code Block |
|---|
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. |