Versions Compared

Old Version 3

changes.mady.by.user Neha Nimgire

Saved on

compared with

New Version 4

changes.mady.by.user Vinayak Pawar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: To be consistent with select queries, converted the table and column names in update DML to lowercase

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.

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 CATISSUEupdate catissue_QUERYquery_FOLDERS set OWNERfolders set owner = 24 where name= in ('Admin queries');
# you can add more folder names to the IN clause separated by comma.