Need help with specifying period of time on search filter

[Ralph Licup]

Hi,

Can someone help me with my filter? basically, I need to create a filter for specific Project on a specific time of the day.

like for example, I need to create a filter where I can see tickets being create during 10PM to 6PM.

[Prerna Sony · Accepted solution]

Hello @Ralph Licup 

Welcome to Atlassian Community!

For dynamic dates and time, you can try something like 

project = SO and created > startOfDay("-2h") and createdDate <  startOfDay("-6h")

This will give you night tickets for every day. I.e. tickets created between 10 pm (last day) and 6 pm (of last day) 

Hope this helps !

Thanks,

Prerna 

[Ralph Licup]

Awesome Thanks! let me try that now!

[Ralph Licup]

This work great!, just needed to change the symbol after createdDate to greater than Sign. thanks again!

[Dexter de Vera]

Hi @Ralph Licup , you mean issue created today 10AM to 5PM? You can use this jql:

created >= startOfDay(10h) and created <= startOfDay(18h)

startOfDay start with 12AM plus the 10h (hours) equals 10AM and 18h (hours) equals 6PM

created >= startOfDay(10h) - check tickets is created after or equal 10AM

created >= startOfDay(18h) - check tickets is created before or equal 6PM

AND - a condition to check both JQL are met.

[Frederik Vantroys]

hi @Ralph Licup ,

Something like this should work :

project = "XXX" AND created >= startOfDay("-1d") + "22:00" AND created <= startOfDay() + "06:00"

[Ralph Licup]

Awesome Thanks as well! let me try that now!

[Ralph Licup]

it keeps showing me errors with plus sign being a special symbol and needs to be enclose. sorry I'm new to to JIRA syntax.