JQL for parent child field

[Katherine Stevens]

Hello!

How do I write a query to find out if the parent field has been filled out but the child is empty?

So far I have this, but it's currently showing me that the parent is 'deposit', and the child could be anything.  The problem is I only want results where deposit is the parents and there is no child.

project = SMS AND "Ticket Category" in cascadeOption(22409) AND resolved >= 2022-12-01

Thanks!

[mauricio.groth · Accepted solution]

Hi @Katherine Stevens

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, it’s not possible to find your parents who have a specific field whose child has an empty field using only JQL of Jira. You can check a few apps in the marketplace that extend the search for you by clicking here

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find your parents, whose children have the Ticket Category empty.

issue in parentsOfIssuesInQuery("'Ticket Category' is empty") and project = SMS AND "Ticket Category" in cascadeOption(22409) AND resolved >= 2022-12-01

If you have any other questions about this query, please contact our support. 

We’ll be happy to help you!
Best regards,
Maurício