nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Why do the queries require change in the format - what is the cause?

William Causey

We are seeing a change for our JIRA Queries as follows: We where using the following query:

project = GVUKSUP AND (resolved >= startOfDay(-6d) and resolution != UnResolved) ORDER BY resolved

This worked until a few days ago - getting only the tickets that were not Unresolved within the last 6 days but now the same query changed and is required to be typed as follows:

project = GVUKSUP AND (resolved >= startOfDay(-6d) and resolution != "\"UnResolved\"") ORDER BY resolved

My question is what would cause this change to be made to the query? It seems working queries are needing changes and we need to know what is the cause of the changes.

Accepted answers

All comments

Nic Brough -Adaptavist-

I have a nagging doubt about this one - could you quickly check your list of resolutions under Admin -> Issues -> Resolutions - what is the full list?

William Causey

This is the full list:

Fixed
Won't Fix
Duplicate
Incomplete
Cannot Reproduce
Applied Package Upgrade
Data Refreshed
Enhancement Request
Fixed Indirectly
Fixed in Code
Functions as Designed
No Action
Request Completed
Cancelled
Done
UnResolved (Default)

JamieA

ouch. If you need to fix that you can try: https://jamieechlin.atlassian.net/wiki/display/GRV/Built-In+Scripts#Built-InScripts-BulkFixResolutions

Nic Brough -Adaptavist-

ARGH! Get rid of the last one. Kill it. Kill it with fire! Actually, rename it to begin with - something like "bad resolution do not use me" or something. Then you can start on the repairs, it will make your searches work ok again, and it'll be obvious that it's broken. That resolution is an unmitigated disaster - it's telling Jira that the issue is RESOLVED. Doesn't matter what the text of the value is, the issue is resolved. You need to get rid of it as fast as possible. Check for the issues that are currently broken because they're using it - you'll need to re-open them or flip them over to another resolution. Then you can delete the broken resolution. I seem to remember the script-runner plugin has a really easy fix for this if you have it. Rename the resolution and then take a look at that!

Nic Brough -Adaptavist-

"Bother!", said Pooh, as he realised Jamie had beaten him to it while he was typing. Again.

Steven F Behnke

Amazing deduction

Nic Brough -Adaptavist-

Seen it so many times... I try to give people the benefit of the doubt and say it's down to inexperience, but I struggle sometimes. The fact that the value is not there already when you go in to add it should make anyone think "hmm, it appears on-screen, why isn't it on the list already?" and hence "so why am I adding it?".

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

query