Generating change report

[Shanara Sadeque]

Is there a way to generate a report that gives me a list of all change tickets that were implemented in the last 24 hours and all the change tickets that are scheduled to be implemented in the next 24 hours? Also can this report then be emailed automatically?

[Trudy Claspill · Accepted solution]

Hello @Shanara Sadeque 

Welcome to the community.

You can create filters in the Advanced Issue Search screen, save those filters, and set up subscriptions to the filters to have the results emailed to you on a schedule.

This page explains how to search for issues.

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-a-project/

This page includes information on subscribing to saved filters.

https://support.atlassian.com/jira-software-cloud/docs/work-with-search-results/

Using this search functionality you can search for issues completed in the past 24 hours by setting a criteria for the Resolved field.

resolved> -24h

If you want to find issues that are scheduled to be resolved in the next 24 hours you would need to set a criteria for the date/time field where your specify the due date/time for the issue. In this example I'm using "complete by" to represent that field.

"complete by" > now() and "complete by" < 24h

You would want to add criteria to each of those for the Type of the issue and the Project the issue is in.

project = <your project> and Type = <change ticket issue type>

[Shanara Sadeque]

Hi @Trudy Claspill 

Thanks for the detailed explanation. 

How do I construct a JQL that displays 2 issue types while also filtering the end date?

So I'd like the filter to show tickets with an end date in the last 24 hours with the issue type being either "standard change" or "CAB change" 

[Trudy Claspill]

Hello @Shanara Sadeque 

You would add to your JQL a criteria to evaluate the issueType field.

It sounds like you would benefit from reviewing the documentation for issue searching.

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

You can switch to the Basic Search option:

And then use the options available to indicate you want to search for issues of specified types by check marking the types you want to include:

After completing that step

...you can Switch to JQL to see what the JQL syntax looks like: