JQL for parent child field

Katherine Stevens December 28, 2022

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!

 

1 answer

1 accepted

1 vote
Answer accepted
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 28, 2022

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events