how to filter the epics with only one issue with satus "Maintenance"?

Question

Hi,

I have a project with 4 issue types (Epic, Sesnor, Battery and Charger) and 2 status (Available and Maintenance). Each Epic contains the other 3 issue types (ex: the Epic xxx contains one Sensor, one Battery and one Charger). I would like to create a filter to display the Epics when the following conditions are true:

* Epic status is Maintenance (I think the JQL sould be issuetype = Epic AND status = Maintenance)
* Sensor status is Maintenance (I think the JQL sould be issuetype = Sensor AND status = Maintenance)
* Battery and Charger status are Available (I think the JQL sould be issuetype in (Battery, Charger) AND status = Available)

Is it possible?

Maxamed Xuseen_5dhnu9 · Answer

Battery charger Samsung mobile phone

Maxamed Xuseen_5dhnu9 · Answer

Battery charger Samsung mobile phone

Charlotte Santos -Appfire- · Answer

Hi @Henrique Olmo Salles

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find the Epics with the conditions you want:

issue in epicsOfChildrenInQuery("type = Sensor AND status = Maintenance") AND status = Maintenance AND issue in epicsOfChildrenInQuery("status = Available AND issuetype in (Battery, Charger)") AND status = "Maintenance"

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Charlotte