‘Fix Version’ on an Initiative is the same as the ‘Fix Version’ on all its attached Epics

[Chris Waller]

Good Afternoon All,

As you can see from the question I am trying to  find out if it is possible to check the fix version on an initiative and compare it to the fix version on all its attached epics. I have tried something like this, this morning, but obviously it didn't work. Any help would be greatly appreciated.

TIA  

[John Funk]

Hi Chris,

Can you share what you have tried? There was nothing attached to the question. 

[Chris Waller]

John,

I created a filter as below. The fields I have displayed are as follows:-

Key        T            Epic Name         Fix Version         Parent Link       Reporter             Status Category               Fix Version

project = "Payment" AND issuetype = Epic AND "Parent Link" is not EMPTY AND fixVersion is EMPTY AND StatusCategory != Done ORDER BY reporter, key

What I am trying to do is find where the fix version of the Epic is different to the fix version of the Initiative. Being relatively new to JIR the filter might look a bit messy to some, however, it does work with the exception of the initiative fix version. 

[Chris Waller]

John,

I presume what I am trying to do is impossible or your no able to help. That's OK and no shame in that, however, are there other resources within the Atlassian Community that could provide an answer?

TIA 

[John Funk]

Hi Chris - so sorry, I was out for a week. 

So you are getting rows back for the query but the fixVersion column has values? Is that the problem? 

[Chris Waller]

Morning John,

Thanks for getting back to me. the fixversion column for the epics is displayed, however, i wanted to compare that with the fix version that is on the corresponding initiative, however, it appears to me that you cannot display that FixVersion at the same time. What I am trying to do is find where there are differences and bring to my colleagues attention.

Do you know how I can do this, or have you any suggestions?

TIA

[Bill Sheboy]

Hi @Chris Waller 

Adding to John's ideas...

You cannot perform that check/query with out of the box JQL.  You could do probably do it with a marketplace addon for JQL.

As a work-around, you could detect this condition using automation rules.  For example:

• trigger: issue field fixVersion changes
• condition: issue type is epic or initiative
• condition if/else structure:
  • if condition: if issue type is epic
    • branch: to the parent
      • advanced compare condition: {{issue.fixVersion}} doesn't match the {{triggerIssue.fixVersion}}
      • action: notification, such as with a comment mention or send an email
  • else condition: // this is the initiative
    • branch: on children of the initiative
      • advanced compare condition: {{issue.fixVersion}} doesn't match the {{triggerIssue.fixVersion}}
      • action: notification, such as with a comment mention or send an email

You may need to tweak this if there can be more than one fixVersion involved.  To learn more about automation rules, please review these documentation and examples:

• https://www.atlassian.com/software/jira/guides/expand-jira/automation
• https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453
• https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

Kind regards,
Bill

[Chris Waller]

Bill,

Thanks for your response. At the moment this is a bit beyond me. I think I am trying to run before I can walk metaphorically speaking. When you have just been thrown into the middle of something like JIRA you have to hit the ground running and I don't think it's working. Not for me anyway. I will certainly keep your response in view and refer back to it. Thanks once again.