Two Dimensional Filter Stat on fixVersion return "Unscheduled" values

[fladnag]

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 ?

[Nic Brough [Adaptavist]]

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?

[fladnag]

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

[Nic Brough [Adaptavist]]

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?

[fladnag]

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

[Nic Brough [Adaptavist]]

>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.

[fladnag]

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)

[fladnag]

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

[Nic Brough [Adaptavist]]

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

[fladnag]

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 !

[Julian Lopez]

I just applied this filter to my projects and was able to take the Unschedule off the view:

category = "IT Projects" AND issuetype not in (Bug, Sub-task) AND resolution = Unresolved AND fixVersion is not EMPTY ORDER BY Rank ASC

I have all my projects under a same category, and I´m not including bugs nor sub-tasks.