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.

[Davide Bonfanti]

1. ET does not deal with Projects as Jira does. ET is a good product for Issue Tracking and Application management in general.

2. ET runs in SaaS.

3. In ET users do not need a licence, therefore we have grown a very large number during these past years. In ET some users are external but we are not going to grant external users access to Jira.

Thanks for taking the time to look at this.

[Tinker Fadoua]

@Davide Bonfanti

I googled hoping to find an App to help with migrating your projects. I also was thinking may be if you have a DB it will be easy to connect it to a server instance.

I am going to ask other champions for help

[Davide Bonfanti]

I did some google too but couldn't find anything at all.

Meanwhile I am still searching, please let me know if you find anything usefull

thanks

davide

[Tinker Fadoua]

@Davide Bonfanti

I never used this product that's why I will beasking you couple questions:

1. How many projects do you have in ElemenTool?
2. What DB are you using?
3. How many users do you have? Internal? External if any?
4. Any customization?

Best,