JQL

Question

Hi All,

I think my query may be botched. Please see below.

issueFunction in subtasksof("project=AAAA and issuetype in (\"TASK\") AND created (\"20/mar/23\")AND status not in (Cancelled, \"On Hold\")

I am looking for a query to pull a subset of all the subtask assigned to my team example (March 2023 & April 2023),

Tansu Akdeniz · Accepted Answer

Hi @ADENUGES2282

Welcome to the community.

You can use subtasksof function if you want to provide parent criteria. I couldn't catch the requirement clearly. Do you want to see subtasks or parents? Also, how do you define your team? A set of assignees or a cf?

Also take a look at Script Runner functions page.

Trudy P Claspill · Accepted Answer

Hello @ADENUGES2282

Welcome to the Atlassian community!

How is the query not giving you the results that you want? What is it including that you think it should not? What is it excluding that you think it should include?

"issueFunction in subtasksOf()" will give you the subtasks of the issues that match the criteria in the parentheses. What you have in the parentheses is

project=AAA and issueType=Task and created(20/mar/23) and status not in (Cancelled, "On Hold")

That query would give you all the Task in project AAAA which are in statuses other than Cancelled or On Hold, and where the Task creation date has some relationship to "20/mar/23".

However the syntax concerning the Creation Date is not valid syntax:

created(20/mar/23)

What are you trying to accomplish with that criteria? Are you looking for Tasks that were created on that date, or after that date, or something else?

After getting that syntax corrected you will have a list of tasks returned by that part of the query.

Then the "issue in subtasksOf()" will give you all the subtasks under the Tasks.