Generate Report for Non-resolved Issues

[Dearka Chan]

Hello Community. I am now using service management free plan. I would like to supervise all the statuses of the service requests and I don't want any issues not being solved for more than 7 days, how can I generate a report for checking the non-resolved issues with sorting from the time created? 

Do I need to generate the report with JQL or just filtering? Thanks a lot.

[Geethanjali Katagani · Accepted solution]

yes, you can create a filter with the following query and set up a filter subscription to receive email notifications based on the filter's results.

project="Example " AND created >= -7d AND status not in(Resolved, Closed,Done)

[Dearka Chan]

Thanks for your answer and it really helps. May I ask that how to adjust to filter (JQL) to make it to view the non-resolved issues for more than 7 days?

[Geethanjali Katagani]

you can use below JQL query

project="Example " AND status not in (Resolved,Done) AND NOT status changed and updated <=-7d

let me know if you encounter any issues or have any questions.

[Danut M _StonikByte_]

Hi @Dearka Chan,

I strongly recommend creating a dashboard in Jira  with all the necessary gadgets in-place for tracking your JSM projects. 

See this article on our blog for how to create such a dashboard: An effective dashboard for Service Desk and Customer Support teams in Jira Service Management  

I hope this helps.

Thank you,

Danut Manda

[Akbar Gulaliyev]

To make easier tracking your resolved/unresolved issues, it's highly recommended to use Resolution field and fill it via post-functions in workflow. 
here is documentation