List all JIRA tasks that are not blocked by other tasks

jira jql
FMaz008 picture FMaz008 · Feb 6, 2012 · Viewed 7.2k times · Source

Using JIRA 4.4.3,

I've created a filter that list all the tasks that: - The current user is assigned to; - are Open; - are not blocked by any other task.

To make it clear: the task that are ready for a user to work on.

We've installed the Craftforge JQL Functions plugin, and I've come with the following JQL query:

assignee = currentUser()
AND status in (Open)
AND issue NOT IN linkedIssuesFromFilter("All Issues", "Blocks", "Outward")

The problem is that when an issue that was blocking another issue is resolved, the "Blocks" link still exist -- and I don't want to delete it. But my query doesn't check if the linked issue is closed/resolved or not.

How can I add a condition "inside the IN statement" that will only return queries that are blocking the current task AND that are still OPEN.

Answer

Donald Taylor picture Donald Taylor · Nov 6, 2014

Use this clause from http://www.j-tricks.com/jqlt-links-functions.html:

issue not in linkedIssuesInQuery("status = Open", "is blocked by")

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More