Querying current sprint does not get ame result as Sprint Report

[Maha Tourbah]

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]

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-]

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)