Hello, I am working with the JIRA API in Power BI.
I want to show all tickets that are in currently in the backlog for a specific board. I've noticed that if a ticket gets moved to a sprint and then back to backlog, we get a record for the time the ticket was in the sprint but I can't easily identify the ticket being back in backlog by looking at the sprint information.
Is there a simple way for me to find out which tickets are currently in the backlog? Is there a field that can easily identify the ticket in backlog.
Thanks for the help!
The items on the backlog are defined by those not in Active Sprints, so you can only really look at the Sprint field to determine what's on the Backlog.
This is from the documentation:
An issue will only be visible in the Scrum backlog if:
You would need to look at all the sprint info for the Board, and compare to the sprint your issue is allocated to.
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