Filter Owner.

Ibrahim Dubey June 26, 2014

I want to change a bunch of filter owners, but I would like to do that without login with each user. Is there any way to achieve this on the database?

2 answers

1 accepted

1 vote
Answer accepted
Pedro Souza
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 26, 2014

You can use the following SQL queries for achieve this:

Use this one to discover the ID of each filter:

select * from searchrequest

Then use this one for updating the owner, for the desired filter ID:

update searchrequest set authorname = newowner where id = desiredfilterid

or use this one for changing the ownership according to the username:

update searchrequest set authorname = newusername where authorname = oldusername

Take a backup before running it directly in production.

Best Regards,

Pedro Souza.

0 votes
Vijay Khacharia
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 26, 2014

Hi,

Another option would be to use script runner plugin. It provides built-in script to change the owner of filters and dashboards.

https://jamieechlin.atlassian.net/wiki/display/GRV/Built-In+Scripts#Built-InScripts-Changedashboardorfilterownership

Vijay

Suggest an answer

Log in or Sign up to answer