Got feedback or spotted a mistake?

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

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

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 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 used.

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 comma.
  • No labels