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

Question

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_ · Answer

Try with the following:

* issueFunction in issuesInEpics("fixVersion is not EMPTY") AND fixVersion != issueFunction in parentsOf("fixVersion is not EMPTY")
* issueFunction in issuesInEpics("fixVersion is not EMPTY") AND fixVersion is not EMPTY AND fixVersion != issueFunction in epicsOf("fixVersion is not EMPTY")

Best regards

Sam

Lee Mulleady · Answer

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_ · Answer

Hi @Lee Mulleady

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

* Filter for Parent Issues: First, identify the parent issues (requirements) that have child stories. You can use JQL to find these parent issues.
* Filter for Child Issues: Then, identify the child issues (stories) that are linked to the parent issues.
* 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.fixVersionNote: 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