Hi
Is there a way I could filter an issue within a specific time but also it has an interval date?
Something like this:
project = SO AND created > "2017/11/20 22:00" AND created < "2017/11/21 6:00"
I would like to know the number of tickets by night within a single day.
Hello Glenn,
For dynamic dates , you can do something like
project = SO and created > startOfDay("-2h") and createdDate < startOfDay("+5h")
This will give you night tickets for every day. I.e. tickets created between 10 pm (last day) and 5 am (of current day)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Richard Cross - there's no difference, one's an alias (but don't ask me which one!). 😅
If you have any other questions, definitely start a new thread on Community! (Click Ask the community in the header).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Glenn,
You certainly can, just use:
createdDate >= "2017-11-16 14:00" and createdDate <= "2017-11-16 23:00"
That should give you the tickets created during the specific time window you are looking for.
Hope this helps,
Tyler
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How to get last one week/month ticket created between 10 PM to 8 AM?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Paul.j
I'm not the JQL expert, but the following query works for me:
project = ProjectName and created >="yyyy/MM/dd 10:00" AND created <="yyyy/MM/dd 08:00"
Hope this helps.
Best regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, not sure what you meant but writing
created >="yyyy/MM/dd 10:00" AND created <="yyyy/MM/dd 08:00"
does not work : you have to specify year/month/day or else use startofday() etc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, you should specify year/month/day. That was only an example.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.