The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

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. 

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events