+1 for @Ilya Turov 's answer if you are using a Scrum board. If you're using Kanban you would need another way.
Could you base the query on the status? Certainly for Kanban, you may well have a status that is reserved for the backog (often called Backlog). If you go to Board settings and choose Columns, you can see which statuses appear on the Active board and which don't
You don't mention whether you're using cloud or server Jira, but I think both are similar (I have cloud, so my description is based on that).
You will need to be an Admin of the project. Click on the three dots in the top right hand corner and Board settings is the first option.
You can see from the screenshot below that we have an explicit status for the Backlog - if you don't, this would probably not work. You could create another status and make it the "backlog" one
Yes, that's the issue. Next-gen Kanban boards don't seem to be able to differentiate between items in the backlog and those on the board. I can't see any way around this, unless if you create a new field which you manually set as something goes on the board (which is far from ideal)
I guess, if issue is still in the backlog, it's not in any sprint, so looking for something like "sprint is EMPTY" might be a start.
There are also functions like "sprint in openSprints()", "sprint in futureSprints()" or "sprint in closedSprints()"
For more discussion on it you can look at some past topics.
When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events