Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Generating change report

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?

1 answer

1 accepted

0 votes
Answer accepted
Trudy Claspill Community Leader Dec 02, 2022

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.

This page includes information on subscribing to saved filters.

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>

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 Community Leader Jan 11, 2023

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.

You can switch to the Basic Search option:

Screen Shot 2023-01-11 at 12.53.48 PM.png

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:

Screen Shot 2023-01-11 at 12.55.01 PM.png

After completing that step

Screen Shot 2023-01-11 at 12.55.30 PM.png can Switch to JQL to see what the JQL syntax looks like:

Screen Shot 2023-01-11 at 12.57.20 PM.png

Suggest an answer

Log in or Sign up to answer
Site Admin

Atlassian Community Events