Sprint Health Gadget is not picking up the appropriate statuses using its exisiting JQL

[Jagriti]

The JQL for the " In progress" part of the gadget seems incorrect , the JQL being used to fetch the data is broken/incorrect /incomplete .When I update/fix this JQL , it is not saved for the gadget ; the gadget still uses the incorrect/broken JQL

[Nic Brough -Adaptavist-]

Well, no, you can't save broken JQL.  Try correcting the incorrect search and saving it.

[Jagriti]

Thanks Nic , but I didnt quite get you ,when you say "incorrect search and saving it"

Could you please assist with some screenshots .

Thanks

[Nic Brough -Adaptavist-]

Look at the screenshot you gave, note that your query is wrong and the error message in red is telling you what the problem is.  Correct that first, then we can look at everything else.

[Jagriti]

That is a built in query used by the gadget ,when i try to fix  this JQL , it does not save.

[Nic Brough -Adaptavist-]

It's not the built-in query used by the gadget - it can't be because it doesn't work.

Please, correct it and see what it returns in the issue navigator - we need the list of issues you are reporting on to see why the gadget might be wrong.

[Jagriti]

Thanks Nic but I Updated it , it does not help.

Please refer my attachment to see the steps i have been performing , is there anything i am missing?

Thanks

[Jagriti]

@Nic Brough -Adaptavist-  please help with this issue too. 

Thanks

[Jagriti]

Please assist 

[Nic Brough -Adaptavist-]

Ok, I think there's a bug in the "look at this issue list" function there, not the JQL the gadget is running.

What we need to do next is go back to what does work. Could you give us the board filter, and then give us the numbers of how many issues it returns in each status when you add "and in sprint 'PBFF Sprint 39"?  (An easy way to do this is save that filter and use it in a "filter statistics" gadget, selecting status as the grouping, and "include unresolved" enabled)

[Jagriti]

• following JQL to pull all parent issues (task/story/incidents)

    project = "PoP Branch F2F Development Team" AND (issuetype = Story OR issuetype        = Incident OR issuetype = Task) AND Sprint in openSprints() ORDER BY assignee ASC

   returns 49 issues total

• following  JQL fetches all the child issues for the above parents ( subtask, bug)

    project = "PoP Branch F2F Development Team" AND issuetype in (Sub-task,"Bug (ST)     ") AND Sprint in openSprints() ORDER BY assignee ASC

    Returns 302

the gadget calculates the in statuses using story point , so i think it references the task/story/incident level. 

But when you navigate to the issues in each status type it displays a list of all issues in that particular status and that is how i realized that query is broken 

• following JQL fetches everything in open sprint (parent and its children)

       project = "PoP Branch F2F Development Team" AND Sprint in openSprints()  

      Returns 355

Status break down:  Branch-To Do

Gadget returns : 83

My query for sanity check returns : 83

project = "PoP Branch F2F Development Team" AND Sprint in openSprints() AND status = "Branch-To Do"

Status break down:  In progress ( this includes following interim in progress statuses- Branch-Dev & Test","Branch-Dev Done",Branch-Impediments,"Branch-INT Done","Branch-Testing(INT)","Branch-Testing (QA) )

Gadget return : no value , error . status in ("Branch-Dev         Error in the JQL Query: The quoted string 'Branch-Dev ' has not been completed. (line 1, character 12)

My query return :169

project = "PoP Branch F2F Development Team" AND Sprint in openSprints() AND status in ("Branch-Dev & Test","Branch-Dev Done",Branch-Impediments,"Branch-INT Done","Branch-Testing(INT)","Branch-Testing (QA)")

Status break down:  Branch-Done

Gadget Return : 103

My query returns: 103

project = "PoP Branch F2F Development Team" AND Sprint in openSprints() AND status in (Branch-Done)

-----------

Total issues in the sprint using the JQL   project = "PoP Branch F2F Development Team" AND Sprint in openSprints()  = 355 

adding up individual statues generated by my quires above : 83 +169+103 = 355

Gadget fetches 169 less which is because of the - in progress part (as above)

Hope this is what you were looking for.

[Nic Brough -Adaptavist-]

I'm afraid this is mostly useless to us because the filters are not showing us what you have overall and what is in the sprint the gadget is reporting on.

Could you give us the board filter, and then give us the numbers of how many issues it returns in each status when you add "and in sprint 'PBFF Sprint 39"?

[Jagriti]

• The board filter 

project = "PoP Branch F2F Development Team" OR "Project Team" = "Branch Antonov" ORDER BY Rank ASC 

returns = 1946 issues 

• Board filter for sprint 39

project = "PoP Branch F2F Development Team" OR "Project Team" = "Branch Antonov" AND sprint = 202

Returns = 1883 issues

• Board filter for sprint 39 , status "Branch to do"

project = "PoP Branch F2F Development Team" OR "Project Team" = "Branch Antonov" AND (sprint = 202 AND status = "Branch-To Do")

Returns = 1883

• Branch filter for sprint 39 , status "Branch in progress" 

project = "PoP Branch F2F Development Team" OR "Project Team" = "Branch Antonov" AND (sprint = 202 AND status in ("Branch-Dev & Test","Branch-Dev Done",Branch-Impediments,"Branch-INT Done","Branch-Testing(INT)","Branch-Testing(INT)","Branch-Testing (QA)"))

Returns = 1883

• Branch filter for sprint 39 , status "Branch Done" 

project = "PoP Branch F2F Development Team" OR "Project Team" = "Branch Antonov" AND (sprint = 202 AND status = Branch-Done )

Returns = 1883

Something doesn't seem right as all statuses return the same count.

I hope this is what you were expecting ? Else can we have a call please .

[Jagriti]

Hi 

Did this help ?