Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,554
Community Members
 
Community Events
165
Community Groups

Extracting JQL filters through SQL query

Edited

Hello Community,

We are renaming 20 Jira project names in our global Jira instance. There are multiple Users Who saved JQL filters based on the Project names, by changing the names of Jira projects will effect the JQL filters.

Please help me with SQL query to extract all the JQL filters which used project names to create filter. 

Thanks in advance

Rajkumar 

2 answers

2 accepted

0 votes
Answer accepted

Hi @jenne rajkumar ,

welcome to the Atlassian community!

Through the following query you can extract filtername, author and JQL

select filtername, authorname, reqcontent
from searchrequest;

Hope this helps,

Fabio

Hi @Fabio Racobaldo _Herzum_  Thanks for the query, this works for view all the filters in Jira. Is there a way I can view, only filters which are being under certain project category?

Unfortunately, filters are cross projects and they are not categorized. You could search for reqcontent but it depends from your JQL filter.

Hope this helps,

Fabio

Thanks for the update

0 votes
Answer accepted

You can get the saved filters like this:

select * from searchrequest


Project are in the "project" table.

With these you should be able to compile the query you're looking for.

Thanks for the answer @Aron Gombas _Midori_ I can get all the filter in our Jira instance. I'm looking to filter based on project name or project category. Is there way?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,875 views 37 49
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you