Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Need JQL to filter all tickets of past 4 months created between night 10 PM to 6 AM IST

Use case:

I am trying to create a chart to get all the tickets created between night 10 PM to 6 AM IST, the chart should have months in X axis and count in Y axis. Data needed for past 4 months.

I tried using the below mentioned JQl but it only returns me ticket for one day and the same is required for atleast 4 months.
project = L3I AND created > startOfDay("-2h") and created < startOfDay("+6h")

1 answer

1 accepted

0 votes
Answer accepted

Hello @binay_yadav 

Welcome to the community

I don't believe there is a JQL that can be used out of the box for JIRA Cloud to get you this information.

You could probably find an app to add to your JIRA instance that would help with this. Alternately you could investigate adding a custom field to track the hour of the day when an issue was created, and seeing if you can set that field for each issue using the Automation feature to evaluate the Created date/timestamp.

Hi @Trudy Claspill  Thanks a lot for your help, can you please suggest any add on for the use case to work or else I'll try the automation method 🙂

Sorry, no, I cannot. It is not a use case in my company so I haven't had to find an actual solution. If you do an internet search for "jira report on tickets created during time of day" or something like that then I'm sure you'll find other community posts and maybe even links to apps in the marketplace.

Like binay_yadav likes this

@Trudy Claspill  Thanks a lot for helping out :) 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

⚡️NEW Group for Confluence Cloud Admins

Calling all Confluence Cloud Admins!  We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...

91 views 2 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you