I am trying to create a filter on tickets created by a certain group that are not closed and want total tickets by age- <30 days, 30-60 days and >61 days. Is this query possible in version 4.1? any suggestions on the best way to accomplish this?
currently set up as:
project and issue type and reported by and status !=closed and createdDate = "<30d" AND "=30-60d" AND ">61d"
Hi
this should do it:
< 30 days: createdDate >= -30d
30 - 60 days: createdDate >= -60d AND createdDate <= -30d
< 60 days: createdDate <= -61d
Best regards
Thomas
Tom this is very helpful. I find the syntax very confusing and counter-intuitive.
The last line you typed seems to have something wrong perhaps:
< 60 days: createdDate <= -61d
Did you mean this?
> 60 days: createdDate <= -61d
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.