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

[Henrique Olmo Salles]

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:

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

Is it possible?

[Maxamed Xuseen]

Battery charger Samsung mobile phone 

[Charlotte Santos -Appfire-]

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

[David Blank]

Hi @Henrique Olmo Salles and welcome to the Atlassian Community!

You might want to add a filter for your Project to them ( like: project = yourprojecthere)but other than that these queries all look good to me! Have you tried going to "All Issues" or creating a new filter and trying it out?

[Henrique Olmo Salles]

Hi @David Blank . Thanks for the welcoming.

I tryied this filter but got no results... I'm attaching some prints of the resolts and one exemple of the epic.

project = INV AND (issuetype = Epic AND status = Maintenance) AND (issuetype = Sensor AND status = Maintenance) AND (issuetype in (Battery, Charger) AND status = Available)

[David Blank]

I apologize for my misunderstanding! I was thinking you were using 3 separate queries. Unfortunately to combine the 3 queries I think you need an extension from the app store.

I've seen this one mentioned: JQL Search Extensions for Jira & reports

[Maxamed Xuseen]

Battery charger Samsung mobile phone