JQL query filter

Question

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?

padraik · Answer

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

host321 · Answer

Without additional installation no way?

Because need permission on it

padraik · 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")