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

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

JQL for Searching for a specific time slice per day for a month

Hi,

I have been asked to generate a report from Service desk about how many requests have been raised between 7:30am and 8-30am each day for the month and im unsure how to do this.

 I have the JQL for a single day but unsure how to make it display this time slice for the month.

 

Cheers

Brad

1 answer

1 accepted

0 votes
Answer accepted

Hello Brad,

Thank you for reaching out.

We completely understand your requirement to have a JQL query to display issues created in a specific time span of the day during a specific time range, however, I'm afraid there is not a function to return this kind of information with JIRA JQL.

Since we understand this would be a useful feature, we have a feature request opened with our development team to get it implemented:

Allow a JQL query for a specific time span of the day, from a period of time

Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.

As a workaround, you can export the issues to a CSV file and use a spreadsheet editor (Office, OpenOffice, Numbers, etc) to perform the query, as detailed in the feature request above.

Let us know if you have any questions.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Asked in Jira Service Desk

Calling all Mindville Insight users, we need your help! (there might be swag involved)

Hello Insight users,  As part of our (Mindville's) acquisition by Atlassian, our training team is looking to build some new Insight training materials and we want to hear from you!  ...

276 views 4 6
View question

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