Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with JQL: the != operand not working with resolution

Joe Pitt
Community Champion
December 29, 2023

I'm trying to exclude one resolution value from a filter. I'm not the best with JQL

I'm trying Project = nbisoa AND issuetype = Observation AND resolution != Declined.

I'm getting this message: The operator '-' is not supported by the 'resolution field

 

3 answers

2 votes
Dan Breyen
Community Champion
December 29, 2023

Your syntax looks correct to me, and I'm able to run it with the same fields and operators (I need to change the project and issuetype) but I'm on the cloud. For testing, if you say 'resolution = Declined' does it work?  

Can you try 'resolution not in (Declined)'?  That should work too.

I looked and didn't see any specific open issues around that on Atlassian's Jira site. (jira.atlassian.com)

I'm not sure what version of Jira Server you're using, so I couldn't narrow down my search.

0 votes
Laurie Sciutti
Community Champion
December 29, 2023

Hi @Joe Pitt - can you provide a screenshot of your JQL query with the error?  Echoing everyone else’s answers, your syntax looks correct so a screenshot may be helpful for us to help troubleshoot. 

Joe Pitt
Community Champion
January 2, 2024

Not declined screen.png

0 votes
Pierre Ibrahim
Contributor
December 29, 2023

Hi @Joe Pitt 

That's very odd, I don't get that error on my end, have you tried not in instead of != and encapsulate in parentheses?

Joe Pitt
Community Champion
December 29, 2023

Yes, and I get the message not in doesn't work with the resolution field. I even tried letting it suggest options and it suggested != and Declined was listed as a resolution value

Pierre Ibrahim
Contributor
December 29, 2023

That is definitely odd! I'm on JIRA datacenter, I'm able to use != as well as not in for resolution.

Let me ask though, since JIRA does allow creating customfields with the same name, did you or someone on your team by chance create a free text type resolution field? Those will only take ~ and !~ if I'm remembering correctly

Joe Pitt
Community Champion
December 29, 2023

No. I'm a project admin and the system resolution field is the only one in the projects I administer.  I also tried the ~ for Declined and that didn't work.  

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events