JQL filter not working correctly

[Jenny Wilder]

I have several JQL filters set up for my dashboard.  They are all set to pull issues that were in a certain status during the sprint but are no longer in that status.  One of the filters is not pulling issues in that I know should be there.  Any idea why this might be happening?

[John Funk]

Hi Jenny - Welcome to the Atlassian Community!

It might be a timing issue. For the example you shared, it might be on the 2 day borderline (today is June 10 and your query says through June 8). Maybe change your query out a day just for fun to see if it shows up.

[Jenny Wilder]

Hi John,

Thank you for the suggestion.  We actually have changed the dates to multiple different dates and still the issues aren't showing up.  Any other thoughts?

[John Funk]

That's really weird! If you execute the query outside of the Dashboard do you get the same result (no issues)?

And you have verified that each condition is indeed on the card? So if you take the date checks completely out do you see the cards you expect to see?

And then leave the date checks in but take out the part about the spring that it belongs to, do you see the cards you expect to see?

Grasping here with a little manual debug  :-)

[Jenny Wilder]

No, even if I remove the sprint I still get no results and if I leave the sprint but remove the dates still no results. I'm stumped

[Bill Sheboy]

Hi, @Jenny Wilder 

In your screen grab, there appears to be a space within the quotations for the project name in the JQL: "Tech Project Management Curriculum "

Is that the actual name of the project, with the trailing space? If not, that would match no projects and so show no results, right?

[Jenny Wilder]

Thanks, Bill.  That's not it either.  When I start typing in my project name I choose the one that pops up and it puts in the space.  The space is also there in my filters that are working.  :) 

[Bill Sheboy]

Very odd... John's advice is a good way to proceed: Find an issue you *believe* should be included in the results, and then build the query piece by piece to figure out what is removing the items.  Then you can adjust accordingly.  For example:

project = X

project = X AND sprint IN (nnn)

project = X AND sprint IN (nnn) AND status WAS old_status

project = X AND sprint IN (nnn) AND status WAS old_status AFTER date1-1d

project = X AND sprint IN (nnn) AND status WAS old_status BEFORE date2+1d

project = X AND sprint IN (nnn) AND status WAS old_status DURING (date1, date2)

etc.

When the item disappears from the results, you can investigate and adjust as needed.  

[Jenny Wilder]

I ended up opening a support ticket and it seems this issue is related to a known bug that has been being worked on for quite some time :(

[John Funk]

Can you share the bug here?

[Jenny Wilder]

https://jira.atlassian.com/browse/JRACLOUD-72180

[John Funk]

perfect - thanks!