Unable to get a query to display on dashboard even though it returns results

Question

I'm running the following query: project = DEVO AND issuetype in standardIssueTypes() AND status = Done AND statusCategoryChangedDate > startOfYear() ORDER BY "Actual End"

It returns five results. When I attempt to use a widget to display on a dashboard, it returns No matching issues found.

Which widget can I use on the dashboard to display only the issues that have been set to status = DONE for date range 2021/01/01 00:00 to today?

Cheryl Lacy · Answer

I used filter counts and selected: Build Custom Count, More, Completed Date, Between, 01-Jan-2021 and 14-Jan-2021. It still returned 1,292 results. It should have been 5 results.

Type: All

Status: Done

Priority: All

Hmm - looks like I may have found a bug. I noticed that when I select the radio button for Between and then pick the dates from the calendar, it doesn't update and still lists All for the selection and deletes the date range I had entered. :(

KAGITHALA BABU ANVESH_z1zl10 · Answer

Hi ,

Filter results is the only gadget, where you can add Dates in the header , can you please check it.

Veronique DUFOUR · Answer

@Cheryl Lacy Have you tried another gadget if it works ? Or start with a more simple query to see data in the widget then refine the filter?