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.
Another option would be to use script runner plugin. It provides built-in script to change the owner of filters and dashboards.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG