Two Dimensional Filter Stat on fixVersion return "Unscheduled" values

Hi,

I have a simple JIRA project (v6.4.14) with :

* 2 fixed versions  "dev" and "prod"

* multiple components

 

I added a Two Dimensional Filter Statistics in my dashboard with :

XAxis = Fix For Versions (all)

YAxis = Components

 

based on a filter with the simple query :

project = xxx AND status = Done AND fixVersion in (dev, prod)

 

The result show 3 columns : dev, prod, Unscheduled, with 1 in Unscheduled for 1 component only !?

 Version  dev prod Unscheduled
Component
Comp1      19    8           1
Comp2      12   18           0
Comp3      1     1           0

The query generated for the Unscheduled value 1 is :

project = xxx AND status = Done AND fixVersion in (dev, prod) AND component = Comp1 AND fixVersion is EMPTY

and return no result when executed (fixVersion cannot be in (dev,prod) AND be EMPTY)

 

I try to change the filter query for avoid that without success :

* adding "and fixVersion is not EMPTY"

* use "fixVersion = dev OR fixVersion = prod"

 

Any fix or workaround for this weird behavior ?

1 answer

0 vote

Could you try running a filter for "project = xxx AND status = Done AND fixVersion in (dev, prod) AND component = Comp1", save it, and put it into a "filter statistics" gadget, with "fix version" selected as the statistic?  What numbers does that give you?

I added a gadget "Issue statistics" with :

* the new filter

* Statistic type = Fix For Versions (all)

* Show Resolved Issue Statistics = Yes

it display :

dev 19
prod 8
Unscheduled 1
Total 28

with the same generated query that return no result for Unscheduled (... and fixVersion is EMPTY)

The raw filter return 19 rows :

8 rows with "dev, prod"

11 rows with "dev"

 

FYI, with Show Resolved Issue Statistics = False, it display no data at all

 

 

Ok, great. 

Two more tests

What does "project = xxx AND status = Done AND component = Comp1 AND fixVersion = Unscheduled" give you?  One issue or none?   (Or many?  Which I don't expect, but could happen)

Can you reindex project xxx and see if that helps?

 

the query return an error :

The value 'Unscheduled' does not exist for the field 'fixVersion'.

I also try with AND fixVersion IS EMPTY :

It return 2 results :

* 1 at "fixed" status but not installed yet (so with no fix version)

* 1 at "Cannot reproduce" status

 

I don't found how to reindex the project, I use the JIRA of my company and I don't see any reindex button on administration page, maybe they disable this action for project leaders.

 

Edit : I tryied to set fixVersion to "dev" for the two issues without fixVersion : it increment the "dev" number (19 -> 21) but the "Unscheduled 1" result is always here

>1 at "fixed" status but not installed yet (so with no fix version)

Ok, that's where the "one unscheduled" is coming from - the no fix version is pulling it up.

What I think is broken now is the "is empty" should find that too.

I'd still try a project re-index.  Admins should be able to do that from the admin options on the project - a drop-down to the the top right of the admin section on the project.

ok, thanks, I will ask to a JIRA admin in my company for the re-index.

 

But it's weird Unscheduled 1 still appear after I set a version for the issue without it (Edit part of previous message ;o)

The Unscheduled value 1 is still here after a JIRA admin made a reindex of the project

That is correct, you have an issue without a fix version.  Does the re-index affect the "is empty" question?

The reindex don't change any result :

* Original filter : fixVersion in (dev, prod)

=> return 19 results with fixVersion (as expected)

* fixVersion IS EMPTY :

=> return 2 results as expected (1 Cannot reproduce and 1 without fix version)

* Query generated by gadget for Unscheduled = 1 : fixVersion in (dev,prod) AND fixVersion IS EMPTY

=> return 0 result : I expected that the query was NOT generated by the gadget or at least gadget display 0 for the result and not 1

 

The problem is that original filter contains "AND fixVersion in (dev, prod)", so, yes I have an issue without a fix version, but I don't expected to have it in gadget results at all !

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Agile

What is ChatOps? A guide to its evolution, adoption, and significance

I am the product of AIM. I can hear that door swinging open and closed in my mind with absolute fidelity. I’d recognize that ding anywhere. At 15, as I typed away into AOL IM, I never imagined that ...

47 views 1 6
Read article

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