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.
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?".
This is the full list:
Applied Package Upgrade
Fixed in Code
Functions as Designed
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!
I still wanted to point at your Script-Runner as the easiest fix! I'm not sure how Atlassian could fix this. I suppose you could stick in a quick dictionary check so that people typing in synonyms like "unresolved", "done", "closed", "ended" and so-on get blocked with a big "don't do this" type warning. Personally, I'd prefer a meta-status fix. Bin the "resolution is set = resolved" approach and replace it with "Issues in status with this flag set on it are resolved". That feels like the way they're heading anyway, given the status categories. (I'd keep resolution as "why/how it's resolved", just change the way the flag works)
Nic - I don't blame the people, most times I've seen this is jira -> jira export import using CSV. It creates a resolution called Unresolved. That is the bug. And so the prevention would be simple enough, prevent creating a resolution with the word that is used to display Unresolved, in all languages, and map that word to <null> when doing imports. Not perfect but a damn sight better than what we have now.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG