Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to bulk change variables in JQL query in lieu of changing each manually?

Deleted user January 24, 2020
  • Someone has shared with me a set of several queries to use as templates for my projects. I have been changing search variables within these queries and "saving as" a new filter. Is there a way to bulk change these query variables so that I don't have to change the set of queries one at a time?
  • In the example query below is a query for project XXX. The variables XXX will be used in a total of 7 queries for the same project. Is there a way to bulk change the XXXs in all the queries at once?
  • issuetype in (bug, story) AND status not in ("In Progress", "Merge Pending", Resolved, "QA To Do", Verified, Done, "QA Testing Blocked") AND ("Environment Found In" = XXX OR "Target Environment(s)" = XXX OR "Target Environment" = XXX OR "Customer(s)" ~ xxx) AND "Ticket Number(s)" is not EMPTY

I'd appreciate your assistance. Thank you, Anne

2 answers

2 accepted

1 vote
Answer accepted
Mikael Sandberg
Community Champion
January 24, 2020

The short answer is no, there is no bulk edit option for filters. The only thing I can suggest is to use a text editor and have all 7 queries in there and do a search and replace, that is the closest you can get to a bulk edit.

Deleted user January 27, 2020

Thank you for your informative response. I appreciate it! Anne

0 votes
Answer accepted
Steve Sauser
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 28, 2020

Create individual queries for each of your criteria then join them together in the end result queries.  

If this is one set of criteria that you change for multiple end result queries:
"Environment Found In" = XXX OR "Target Environment(s)" = XXX OR "Target Environment" = XXX OR "Customer(s)" ~ xxx

Create this and name the Filter "Environments".  Once saved you will have a "Filter ID" and you can join together multiple Filter IDs together (assuming each runs on it's own).  Let's assume the Filter ID = 12345

issuetype in (bug, story) AND status not in ("In Progress", "Merge Pending", Resolved, "QA To Do", Verified, Done, "QA Testing Blocked") AND Filter ID = 12345

This will combine the 2 together, now you can add that "AND Filter ID = 12345" to as many filters as you want and then ONLY change the "Environments" Filter and save it, when you access the other Filters that contain the "AND Filter ID = 12345" will be using the variable query each time.  

Deleted user January 30, 2020

Thank you very much! Anne

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events