What is the JQL query to generate the Sprint Reports

[Charles Famarin]

Within Jira, there is the Sprint Report.  It generates grids like Completed Issues, Issues Not Completed, and Issues Removed From Sprint.  

I'm assuming we can pull the same results from Jira using JQL. 

1. Can we pull the same results just using JQL?

2. If yes, can anyone help me with this please?

I am aware of using add-ons like Script Runner:
https://community.atlassian.com/t5/Jira-Software-questions/JQL-Query-for-quot-Issues-completed-outside-of-this-sprint-quot/qaq-p/886312

I'm looking for only JQL queries please.

[Nic Brough -Adaptavist- · Accepted solution]

Actually, it's simply the board query with "and sprint = xyz" added to it.

The separation of completed/incomplete/added/removed is not searched, it's read from the issues and displayed by the reporting.

[Charles Famarin]

Thanks Nic.  Appreciate the response.  How is this done? ->  it's read from the issues and displayed by the reporting.

For example, I can add the sprint = xyz, but I don't know what was 'removed'.  In fact, if I use the sprint = xyz, I probably wouldn't see the item that was removed.  

[Nic Brough -Adaptavist-]

The code that generates the reports reads the issues and sprints to see when issues were added to / removed from, the sprints.  I can't explain much more than that, the code really does look at the issues and calculates what the charts should look like from there.

That's how the Scriptrunner functions work as well, they read the issues and sprint data to work it out.

[Charles Famarin]

So as I understand, there really are no JQL options here.  There are underlying code logic that helps create the separation.  
I will need to move forward with something like ScriptRunner functions.

Thanks for the insights Nic.  Again, I appreciate the replies here.

[Matthew Mallard]

@Nic Brough -Adaptavist- when you say "That's how the Scriptrunner functions work as well" are you talking about completeInSprint('Board', 'Sprint') function?

[Nic Brough -Adaptavist-]

Yes, all of them.

Scriptrunner is, like all apps, limited by what Atlassian lets it do.  Which in this case is read the issue and sprint data to see where things are in the sprints.