childrenOfIssuesInQueryRecursive not working with "custom_field is empty"

Marco Sorich
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 8, 2024

Dear community

I use "JQL Search Extensions" in the Jira Cloud.

With this I want to get all issues, whose parent (or parent-parent) has no "Esc Level" set. Where "Esc Level" is a custom field of dropdown type with the content "1", "2" and "3". My Jira project is a team managed project and "Esc Level" is a custom field inside this team managed project (in case this is relevant here).

When I execute the following query to search for all issues whose parent is of esc level 1, it works great:

issue in childrenOfIssuesInQueryRecursive("'Esc Level' = 1")

But when I execute the query to search for all issues whose parent has no esc level set yet, I get no results although I have such issues in my Jira:

issue in childrenOfIssuesInQueryRecursive("'Esc Level' IS EMPTY")

Is there any known restriction on the sub-query, which I can use inside of childrenOfIssuesInQueryRecursive()?

 

Regards
  Marco

1 answer

1 accepted

0 votes
Answer accepted
Marco Sorich
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 8, 2024

We found it already on our own.

Problem seemed to be a timeout that has occurred (or a too big amount of found issues in the sub-query). When I change the query to 

issue in childrenOfIssuesInQueryRecursive("project = xyz AND 'Esc Level' IS EMPTY")

it works fine now. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events