How to find mis-matching fix versions between parent and child?

[Lee Mulleady]

We establish requirement tickets and then assign child stories to the requirement for the implementation of that requirement.  I have a need to find stories that a fix version that is different than the fix version of their respective parent requirement.  

[Samuel Gatica _ServiceRocket_]

Hi @Lee Mulleady 

To find mismatching fix versions between parent and child issues, you can use the following approach in Jira:

1. Filter for Parent Issues: First, identify the parent issues (requirements) that have child stories. You can use JQL to find these parent issues.
2. Filter for Child Issues: Then, identify the child issues (stories) that are linked to the parent issues.
3. Compare Fix Versions: Finally, compare the fix versions between the parent and child issues.

Here is a JQL approach to find stories with mismatched fix versions:

issueFunction in issuesInEpics("fixVersion is not EMPTY") AND fixVersion != parent.fixVersion

Note: This query uses the issuesInEpics function from the ScriptRunner plugin to find child issues (stories) with a fix version that does not match the fix version of their parent issue (requirement).

Best regards

Sam

[Lee Mulleady]

Thank you so much for the reply.  I do have the ScriptRunner plugin, so the issuesInEpics function is present.  However, using your query results in the following message: "The value 'parent.fixVersion' does not exist for the field 'fixVersion'." 

Is there a trick to get it to recognize the parent. prefix correctly?

[Samuel Gatica _ServiceRocket_]

Try with the following:

1. issueFunction in issuesInEpics("fixVersion is not EMPTY") AND fixVersion != issueFunction in parentsOf("fixVersion is not EMPTY")
2. issueFunction in issuesInEpics("fixVersion is not EMPTY") AND fixVersion is not EMPTY AND fixVersion != issueFunction in epicsOf("fixVersion is not EMPTY")

Best regards

Sam