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

Need a JQL query for both Date and Time range

Hi Team,

I would like to have a JQL query to filter the jira tickets based on Shift basis per quarter.



Need to query the 6am to 15PM jira tickets for each quarter


Please help.





2 answers

1 accepted

1 vote
Answer accepted
Suvarna Gaikwad
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 20, 2021

Hi @Venkatesh T Gowda This is very interesting requirement. We can filter issues based on date range as below. This example will give you issues created in last quarter from 1st oct to 31st dec.

created >= "2021/10/01" AND created =< "2021/12/31"

However adding time range for the same field 'created' won't help as it will not produce right result and will only consider superset i.e. date range specified.

To filter out issues based on time range, I would suggest to use dropdown custom field say 'Shift' and use it with above query to get required results.

Hope this helps.

Hi @Suvarna Gaikwad , thanks for your update. Sure will try as you suggested.

Basically we need to prepare a report every Month and quarter to get the JIRA tickets created based on the shift we work.

I have tried all the way to get this data but failed.


Is there any way we can come up with this feature? 


Thank you,


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events