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.
Hi John,
Yes, these would be Active Issues (not including the Backlog). So would I still use the JQL?
Yes, you would still use JQL to create the Filter.
Thanks, are you aware of a listing of commonly uses JQL queries?
Hi @Rolondo Talbott
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.
It looks like you're new here. Sign in or register to get started.
