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
Community Members
Community Events
Community Groups

JQL query filter

When closing Sprint, there is an issue with closed tickets but opened subtasks.

Can smbd please help in writing JQL query for closed Story and Task but opened subtasks (statuses re-opened, blocked for development, code review, ready for retesting, testing) to find it quick?

1 answer

Unfortunately, you can't do this in basic JQL.

However, there is a plugin (Scriptrunner) that will give your JQL some additional functionality.

When installed, your JQL would look like this:


type = sub-task and status in ("re-opened", "blocked for development", "code review", "ready for retesting", testing) and issueFunction in subtasksOf("status = closed")

Without additional installation no way?

Because need permission on it

correct, without an addon, JQL does not have this functionality

Suggest an answer

Log in or Sign up to answer

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