How to search tasks based on the fixVersion of their parent epic?

[n/a]

Does anyone knows how we can list up the tasks that their parent Epics has a specific fixVersion?

I want to modify the fixVersion of the listed tasks to match the fixVersion of the parent Epics by bulk-editing.

I don't stick to my approach. Any suggestions are welcome to let child tasks have the same fixVersion of their parents.

[Rahul_RVS · Accepted solution]

Hi @p0n 

For a ready made solution you can try out our plugin, to track progress of issues based on the fixed version of your Epic. We have multiple filters in our app, one of them being FixVersion to visualize complete hierarchy of your Epic and track progress at each level of the hoerarchy

Agile Tools - Epic Tree, Links Tree and Time in Status 

Thanks

Rahul

[n/a]

Hi @Rahul_RVS

Thanks for sharing your plugin. Let me check. 

[Daniel Turczanski - JQL Search Extensions · Accepted solution]

Hi,

With standard JQL you can only get a list of epics with a particular version and then execute another query that checks the epic link is one of the keys returned by the first query. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:

• JQL Search Extensions

After you install the app you can simply search:

issue in childrenOfEpicsInQuery("fixVersion='2.0.0'")

You may want to check out the docs as well.

I hope this helps!

Daniel

[n/a]

Hi Daniel,

Thanks for sharing the nice plugin. This time I'm looking for a free solution, but this plugin is really interesting.

[Bill Sheboy · Accepted solution]

Hi @p0n 

I do not believe that Jira Cloud's out-of-the-box JQL can perform such a query.  Your solution/work-around depends upon how often you need to do this:

• one time: export the issues to a spreadsheet, manually join/query the issues, build a list of keys, and then search in Jira to perform the update
• many times: purchase a scripting addon from the marketplace to enhance JQL
• many times, with cost constraints: investigate Automation for Jira (A4J) rules to see how to dynamically build a query to solve this use case and update the issues

Of note: looking at your example for Epic B, that does not seem to make sense: why would the only task in the epic be in one version (release) but the epic is in another version?

Best regards,
Bill

[Sadeesh Narendran · Accepted solution]

@p0n use 

project = xyz and "Epic Link" = xyz-123 and fixVersion = "version name"

using this u can list down all issues with specified epic link and specified fix version. And then u can bulk edit all those with fix version.

Hope this helps

[n/a]

@Sadeesh Narendran 

Appreciate your help, but I want to modify all children tasks across multiple epics that have a common fixVersion wihthout specifying each Epic one by one since I have too much epics.

For example, I want to pick up Task A-1, A-2, C-1, C-2 from the followings by using their parents' fixVersion "1":

Epic A (fixVersion = 1)
  - Task A-1 (fixVersion = 1)
  - Task A-2 (fixVersion = 2)
Epic B (fixVersion = 2)
  - Task B-1 (fixVersion = 1)
Epic C (fixVersion = 1)
  - Task C-1 (fixVersion = 2)
  - Task C-2 (fixVersion = 3) 

[n/a]

Hi @Bill Sheboy 

Thanks for the suggestions.
I want to check daily-basis, but paid addon is not available this time.
After all I created a script using Jira REST API. I'll check A4J as well.

Of note: looking at your example for Epic B, that does not seem to make sense: why would the only task in the epic be in one version (release) but the epic is in another version?

Sorry for confusing you. This is just an example for explanation, and a lot more tasks reside in each epic actually. This kind of inconsistency typically happens when splitting a large on-going epic during backlog refinement.

[Bill Sheboy]

Thanks for the clarification!

__Bill