Assistance with Tracking Resolved Issues

[Joe Mabus]

I am using JavaScript Chart for JIRA Cloud to track stories by status over time. I have followed the turorials to correctly calculate In Progress work, but cannot get resolved/done work to display using the same method. Here is my query, using issue count in a time series field: issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Epic) and status was in (Done)

‌

One result should display, but I return nothing. What method should I use instead to display work completed over time for a given body of work?

[boydo]

@Joe Mabus Your query looks right to me.

Under the hood, my app only queries Jira using JQL syntax which you can also do from the Issue search page in Jira to debug.

If you can spare the time, maybe reading https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/ might help

[Joe Mabus]

Okay, so the reason I categorized this as a bug is that I am able to use the exact same logic for a different status:

Please observe that data is returned for the following queries:

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status WAS IN ("In Progress")

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status WAS IN ("Open")

‌

Furthermore, using the advanced JQL editor, I return results, for the following query:

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status IN (Done); however, when I put this JQL into the JQL field in the datasets box, I get the following message: Error in JQL Query: The IN operator does not support the use of the during (startOfDay(), endOfDay()) predicate.

‌

What is unique about the ‘Done’ search status in your application that the same query would not work?

‌

[boydo]

To test the query in the advanced JQL editor can you do it like this pls?

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status WAS IN ("Done") DURING ("2021/12/01","2021/12/05")

That’s effectively what my app queries. (Note the addition of the DURING part)

A couple of ideas

One thing you could try is to reverse the logic, and try Status WAS NOT IN ("Open", "In Progress", ...)

[Joe Mabus]

Okay, this is tremendously helpful. Your suggested query in advanced search pulls up 0 results, but the reverse provides one.

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status WAS IN (Done) DURING ("2021/09/01","2021/12/05") - 0 results

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status WAS NOT IN (Done) DURING ("2021/09/01","2021/12/05") - returns results with the done status

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status WAS NOT IN (Open) DURING ("2021/09/01","2021/12/05") - 1 result with the done status.

I am positive that it is a jql thing at this point. We should be clear to close unless you are curious to know how I am going to troubleshoot things on my end. You widget is behaving as expected.

[Joe Mabus]

Okay, this is a known bug that our admin found yesterday.

‌

In order to display the done status, you must use the statusID so that the query appears like this:

issuekey in portfolioChildIssuesOf(TS-84) AND issuetype IN (Story, Chore) AND Status WAS IN (10040) DURING ("2021/09/01","2021/12/05")

Data now correctly displays in the dashboard widget using the ID for the status. We can close this ticket now and hope that Atlassian addresses the issue soon.

[Joe Mabus]

Issue resolved as this is a known issue by Atlassian, adding the statusID rather than the name allows data to display correctly in the widget.