Why aren't issues with a null value in the db for resolution showing up as Unresolved?

Hi, I made a change to some field configurations this morning and had to perform a re-index. After I was finished I noticed that I was only seeing 1 issue in my queue as opposed to the 9 I know are assigned to me. Looking into my filter it turned out the problem was related to specifying a resolution condition. Although I can see in the database that all of the issues that are currently open and assigned to me have a Resolution of null, in JIRA only one of those nine issues is being picked up by the filter ("resolution is EMPTY"). This wasn't happening prior to the re-index. I've updated my filters to try to focus on other values (status, for example) to still try to retrieve the same results. But I'd really like to know what's going on here, if anyone has a clue. It's kind of frustrating to see my MySQL query with a WHERE clause of "resolution is null" correctly return what I expect, when the JQL equivalent does not.

I'm guessing there's a join or something I'm missing that looks at something other than the jiraissue table in my JIRA database. If anyone knows anything about this and can provide some advice, I'd really appreciate it.

3 answers

1 accepted

As it turned out, when making changes to remove the Resolution field from the create issue screen I also hid the resolution field in the configuration for the issues. That resulted in the items failing to show up in the Assigned to Me widget (or get recognized appropriately via JQL). Once I changed the field configuration to unhide the Resolution and re-indexed, the issues started displaying again as expected.

Just wanted to reiterate the problem I'm having. When I go into the Issue Navigator in JIRA and use the query "assignee = currentUser() and resolution is EMPTY" I get back a list of 15 issues. When I use the SQL query of "select * from jiraissue where assignee = XXXXXX and resolution is null;" I get back 25 issues. All of the 25 issues have a resolution of NULL in the database (as would be expected from that WHERE clause). So what I'm trying to grok is where/how something joins on that field and the result is that the display of good issues in the Issue Navigator shows a blank resolution field instead of a value of Unresolved.

If anyone can clue me in as to how I've hosed our database and if it's possible to fix, I'd really appreciate it. Thanks! :)

0 vote

Something is out of whack. I'd try to reindex again, and see if that fixes it.

If not, check for silly things like the value in the database being the string "null", or an empty string, although that doesn't explain why you get the hits when you run sql.

> 'm trying to grok is where/how something joins on that field and the result is that the display of good issues in the Issue Navigator shows a blank resolution field instead of a value of Unresolved

It joins on the resolution table. Have a look at the values in there and make sure there is nothing strange. Also go to Admin -> Resolutions, and make sure there is not a resolution called "Unresolved" or something weird.

> If anyone can clue me in as to how I've hosed our database and if it's possible to fix, I'd really appreciate it.

There are tools that will fix it, eg this one, but first you need to work out what the problem is.

As it turned out, when making changes to remove the Resolution field from the create issue screen I mistakenly also hid the resolution field in the configuration for the issues. That resulted in the items failing to show up in the Assigned to Me widget (or get recognized appropriately via JQL). Once I changed the field configuration to unhide the Resolution and re-indexed, the issues started displaying again as expected.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,209 views 13 19
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot