I am looking for filter that shows me only the tickes form 0800-1600 from Monday to Friday in a month.
Currently my filter looks like.
project in (xyz) AND createdDate >= "2017-12-01" AND created Date <= "2017-12-31" AND Service = abc ORDER BY created DESC
Now i have alle tickets form the Service abc.
How can a reduce this now to the 8h form Monday to Friday?
It is pretty ugly and I would prefer to use a calculated field for filtering. But this will show you all issues created during the working hours of the last 7 days
((created > startofday(-136h) and created < startofday(-128h) ) or
(created > startofday(-112h) and created < startofday(-104h) ) or
(created > startofday(-88h) and created < startofday(-80h) ) or
(created > startofday(-64h) and created < startofday(-56h) ) or
(created > startofday(-40h) and created < startofday(-32h) ) or
(created > startofday(-16h) and created < startofday(-8h) ) or
created > startofday(8h) and created < startofday(16h))
and (created < startofWeek(-24h) or created > startofWeek(24h))
for a hole months it would be even uglier and since there is a limit on query length you would need to split it in several filters.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Michael,
You can use createdDate >= startOfMonth()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cristian
This is fine for easer monthly lists.
Thx
But how can i filter it for the 8h?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It takes automatically the time you set for your instance, not 100% sure, but I would bet for it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also, you can use:
last 2 month: created > startOfMonth(-1)
created only in a specific month: created > startOfMonth(-2) and created < startOfMonth(-1)
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.