Search Query to list all sub-tasks for issues with custom field value

Mike Lee
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!
July 18, 2023

Hi. I'm trying to find the right query for this problem, if such a query exists.

Scenario

  • I have JIRA issues that contain a custom field
  • When creating sub-tasks for issues, the sub-tasks do not inherent the custom field value from the parent (ie custom field is blank for sub-tasks)
  • I would like to create a filter to list all issues that contain a certain value in the custom field along with all sub-tasks that belong to those issues

Example

Project = ABC AND [Custom Field] = XYZ OR sub-tasks of (Project = ABC AND [Custom Field] = XYZ)

Is this possible? 

2 answers

2 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 18, 2023

Hello @Mike Lee 

Jira does not natively support nesting filters in that manner.

You can get the subtasks of issues, but you must provide the actual issue keys for the parent issues.

This can be done with third party apps, though. Are you will to consider getting such an app or do you already have one that extends the issue searching capabilities?

0 votes
Ivo Snajder July 30, 2024

hi @Mike Lee 

JQL

(Project = ABC AND [Custom Field] = XYZ) OR issueFunction in subtasksOf('Project = ABC AND [Custom Field] = XYZ')

works for me

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 30, 2024

@Ivo Snajder 

You need to include with your answer that it requires a third party app, and state which app you are using.

"issueFunction" is not a native Jira Cloud feature. It is supplied by a third party app.

Ivo Snajder July 30, 2024

thanks for information

it's possible. we use several third party plugins/addons

Suggest an answer

Log in or Sign up to answer