Querying current sprint does not get ame result as Sprint Report

Question

Hello,

I am making a simple query to get the stroies of a specific sprint as such:

project = PRJ AND Sprint = Sprint1

and then I am comparing against the results of the jira built-in Sprint Report, the results are not the same and I can't seem to uderstand why ..

Mohamed Adel · Answer

Hi @Maha Tourbah ,

Your query will give all issues under this sprint plus it's sub-task , in Sprint Report it shows all issue types except sub-task.

You can try the following query

project = PRJ AND Sprint = Sprint1 AND type != Sub-task

please let me know if this clarification make sense to you

Nic Brough -Adaptavist- · Answer

Try dropping the project part of the query and just ask "sprint = sprint1", and also check that all status are mapped into columns on the boards the sprint appears on, and all the status have categories (no grey "no category" status)