I've been trying to create a filter that filters all completed tickets of a component by the last 3 months, for reporting purposes. I've looked at numerous Altassian posts and this is the best that I've come up with. It still doesn't work because it doesn't like the >= operator:
status = (Resolved, Published, Completed, Declined, Closed, Accepted, Done) >= startOfMonth() AND component = "End Of Life (EOL)" ORDER BY Rank ASC
Hi @David Whitley ,
Can you please try this?
status in (Resolved, Published, Completed, Declined, Closed, Accepted, Done) and resolutiondate >= startOfMonth(-3) AND component = "End Of Life (EOL)" ORDER BY Rank ASC
That's perfect! Thank you very much. Now that I know about resolutiondate, I'll be able to apply this to many of my current reporting filters. That's exactly what I am after.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You're welcome! I'm glad to hear :-)
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.