Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,076
Community Members
 
Community Events
165
Community Groups

JQL query to filter Tasks and associated Sub-tasks by a field in task

Need help on a JQL query to filter Tasks and associated Sub-tasks by a defined field available in task

Please note that this field is not available in sub-tasks

2 answers

1 vote

Hi,

I'm afraid that it's not possible without an addon

Hi @Priyanka Ravindra Chavan

just to add to Mohamed's answer, this would be easily possible in the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by any issue field. It also understands parent/child relationships between issues.

Here's how this would work:

  • Create a so-called JXL sheet based on a JQL that includes all all the tasks that you are interested in (i.e., all tasks with a certain field value), plus any possible sub-task (e.g. all sub-tasks of the projects that you're generally interested in). Don't worry about the parent/child relationship; JXL will sort this out for you.
  • In your JXL sheet, enable the default issue hierarchy. That's a one-click operation.

You will now see the relevant tasks with their sub-tasks underneath them. All other sub-tasks are in a special bucket that you can just ignore. You can now operate on this list using JXL's capabilities or trigger a number of operations, e.g. an export to Excel or CSV.

Hope this helps,

Best, Hannes

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you