I am looking for a report, that can tell me which Projects have active issues and what those issues are, according to a date range. For example, for Project A, B, C, I want to see what Active Issues there are between 1/1/2019 - 2/1/2019.
Hi Rolondo - Ollie's query will work for the most part, but it depends on what Statuses you have mapped to "Active". The statuses in your workflow will determine which ones should be used. At the very least, it should not include Backlog and Done and those are not Active statuses.
The query will need to be specific to the statues you use in your workflow. If you are on a ticket and click on the View Workflow, it will show you all of the statuses. Then you can write a query something like, project = xyz and status in ("In Progress", Testing, Deploy) where the statuses are what are in your workflow (minus backlog and done).
Does that help?
Now is available add-on which automatically saves all history of issues changes, ordered by the date. It's Issue History for Jira Cloud.
- Use filters to select issues list.
- Set columns to show different fields on the report grid.
- Apply custom date range to filter results.
At the Atlassian Marketplace you can get more information about the add-on and try the trial version of it.
If you have any question, please contact me directly firstname.lastname@example.org.
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
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