JQL: How do I query for Items that are not completely estimated

Paul Edison

Hi,

I'm trying to query in JIRA for items that are not estimated COMPLETELY.

What do I mean:

• If it is a Story it has to have a Story Point Estimate
• If it has sub-tasks all subtasks are estimated (in time)
• If it has no sub-tasks the item has a time estimate on it

Especially the last two items I don't know how to query - is there a way to do that?

Jack Nolddor [Sweet Bananas]

Hi Paul,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

 

1) If it is a Story it has to have a Story Point Estimate

type = Story AND "Story Points" IS EMPTY

2) If it has sub-tasks all subtasks are estimated (in time)

type = Story AND issue IN parentOf(' type IN subTaskIssueTypes() AND originalEstimate IS EMPTY  ')

3) If it has no sub-tasks the item has a time estimate on it

type = Story AND issue NOT IN hasSubtasks() AND originalEstimate IS EMPTY 

 

1,2,3) All together

type = Story AND ( "Story Points" IS EMPTY OR issue IN parentOf(' type IN subTaskIssueTypes() AND originalEstimate IS EMPTY ') OR (issue NOT IN hasSubtasks() AND originalEstimate IS EMPTY) )

(*) Note that this is just an example, you must tune above query to fit your needs.

 

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

 

References:

• Official documentation