Execution of "issueFunction in subtasksOf("resolution = Fixed or Completed")" is not working fine.

The following JQL function is throwing errors:
1. JQL : issueFunction in subtasksOf("resolution = Fixed or Completed")
Error : NoViableAltException(-1@[]).

2. JQL : issueFunction in subtasksOf("resolution = 'Fixed or Completed'")
Error : No issues were found to match your search.

The error is coming for all the values of field Resolution where the value contains more than one word such as Won't Fix, Incomplete Description, Cannot Reproduce, Won't Do, Fixed or Completed.

Our JIRA Instance details:
--------------------
JIRA version: 6.3.12
JIRA tomcat heap size: 16 GB
JQL Tricks plugin version: 5.3.3

Script Runner plugin version: 3.0.6

3 answers

You need to test the inner query separately - this is not going to work on its own, so it won't work as a parameter:

resolution = Fixed or Completed

This should totally work:

issueFunction in subtasksOf("resolution = 'Fixed or Completed'")

"No issues found" is not an error, maybe there are no results for that query?

Try Udo's suggestion and see if that gives the same results. 

Udo's example of Won't Fix not working is because it contains a single quote, but your one doesn't.

Ha, you are correct. It works with "Cannot Reproduce"

thanks for confirming ;-) Udo - can you linkedin with me? "Jamie Echlin".

Always a pleasure confirming good anwers. Thanks for invitation, however I'm only on Xing and have no plans going to linkedin.

Totally fair enough, I forgot that linkedin is not big in Germany. I just wanted your email, perhaps you could send it to me at firstname.lastname@gmail.com , where first and last is Jamie and Echlin ;-)

Mail was sent ;-)

Yes, I get similar errors (used "Won't Fix")

Workaround: create a filter (FilterA)

resolution = "Fixed or Completed"

then use

issuefunction in subtasksof("Filter = FilterA")

Peter DeWitt Community Champion Oct 11, 2018

This is the way to go - not sure why the SubtasksOf is so temperamental.  

Hi Jamie Echlin,

There are results present for JQL -

issueFunction in subtasksOf("resolution = 'Fixed or Completed'")
because I tried to validate if there is any result for the above query or not, by executing the below query:
Project = RISK AND issueFunction in subtasksOf("status= closed")

and got results more than 9K with most of them having Resolution = Fixed or Completed

I have tried creating a custom filter (ResolutionFilter)

               ResolutionFilter --> resolution = "Fixed or Completed"

and then executed the below query and got the result "No issues were found to match your search"

Project = RISK AND issueFunction in subtasksOf("Filter = ResolutionFilter")

 

> and got results more than 9K with most of them having Resolution = Fixed or Completed Do you mean most of the parent issues had that resolution? What results do you get for: Project = RISK AND resolution = 'Fixed or Completed' ?

Do you mean most of the parent issues had that resolution? Yes Project = RISK AND resolution = 'Fixed or Completed' - Returns no Result (Which again seems to be wrong behaviour)

> Returns no Result But there's your problem... so this is not related to the subtasksOf function, which seems to be doing the right thing. Try reindexing all.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,816 views 18 22
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you