nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter for "Last 3 months" by all resolved statuses

David Whitley_u0dmo5

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

Accepted answers

Carlos Garcia Navarro

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

All comments

Carlos Garcia Navarro

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

David Whitley_u0dmo5

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.

Carlos Garcia Navarro

You're welcome! I'm glad to hear :-)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud