You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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 Talbott,
You can query these Issues through JQL. If you need further analysis, exporting Excel and doing data analysis is an optional way.
project in (A,B,C) and updated <=2019-02-01 and updated >=2019-01-01
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
Yes, these would be Active Issues (not including the Backlog). So would I still use the JQL?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Now is available add-on which automatically saves all history of issues changes, ordered by the date. It's Issue History for Jira Cloud.
Plug-in allows:
- 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 zoryana@saasjet.com.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.