It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

Suchitra Singh Apr 07, 2015

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

3 votes
JamieA Apr 07, 2015

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.

Udo Brand Apr 07, 2015

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

JamieA Apr 07, 2015

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

Udo Brand Apr 07, 2015

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

JamieA Apr 07, 2015

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 ;-)

Udo Brand Apr 07, 2015

Mail was sent ;-)

1 vote
Udo Brand Apr 07, 2015

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 Leader Oct 11, 2018

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

1 vote
Suchitra Singh Apr 07, 2015

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

 

JamieA Apr 08, 2015

> 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' ?

Suchitra Singh Apr 08, 2015

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)

JamieA Apr 08, 2015

> 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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira

Here’s what we’re doing to make Jira Cloud faster

Hello Community 🤗 I’m Nikhil, a Product Manager on the Jira Cloud team working on performance improvements. Performance is an ongoing journey and we continue to invest heavily in it. We under...

129 views 1 19
Read article

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