Building a JQL to find EPICs on a scrum board that are missing a certain Story

[Thomas Wilson]

Trying to build a JQL to find EPICs that have component = “EPIC Schedule” AND a Label=”Afloat” that are missing certain “linked” Stories (basically Issues in Epic) that have the following criteria: "summary !~ 'Submit COP'" (missing a story with “Submit COP” not is the Summary)

There are currently:

a. 288 EPICs with component= “EPIC Schedule”

b. 49 EPICS with component= “EPIC Schedule” and Label =”Afloat” and using the Story criteria of NOT having “Submit COP” anywhere in the Summary. But for some reason the query seems to still give me EPICs with the stories that DO have a "summary ~ 'Submit COP'" using the following JQL I built:

project = BAISEA AND issuetype = Epic AND component = "EPIC Schedule" AND labels = Afloat AND issueFunction in epicsOf("summary !~ 'Submit COP'")

I have also attempted to try JQL, also with NO success:

project = "BA ISEA" AND issuetype = Epic AND component in ("EPIC Schedule", "SE Logistics") AND labels = Afloat AND issueFunction in hasLinkType("Epic-Story Link") AND issueFunction in epicsOf("summary !~ 'Submit COP'")

I attempted to use the “issuesinepic”, but i get an error that it doesn’t exist or that I don’t have permission to use it.

[Ste Wright · Accepted solution]

Hi @Thomas Wilson 

This seems to work for me:

project = ABC AND issuetype = Epic AND component = "EPIC Schedule" AND labels = Afloat AND issueFunction in hasLinkType("Epic-Story Link") AND issueFunction not in epicsOf("summary ~ 'Submit COP'")

Ste

[Thomas Wilson]

Stephen,

Awesome, thank you the JQL worked! 

I was able to now build more detailed JQLs for other metrics I have been attempting to extract.

r/Tom Wilson

[Ste Wright]

No worries!

If this did help, could you accept the answer? :)

Ste

[Thomas Wilson]

👍