Im trying to create a report for tickets closed last month. I have ticket closed this month see below. Any help would be appreciated.
"Assigned IT Service Team" = EnterpriseSystems AND status = resolved AND resolved >= startOfMonth() OR "Assigned IT Service Team" = EnterpriseSystems AND status = Closed AND resolved >= startOfMonth()
This JQL should do the trick:
resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1)
Thank you for responding. I tried that and it shows me resolved from Feb 2018 to March 2018. I want to only see resolved in Feb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That's odd. I've just tried it in my instance and it returned issues resolved ONLY in Feb 2018. Are you positive that you have used the EXACT JQL I've provided?
To be extra clear, it could've returned issues resolved in Feb 2018 AND March 2018 ONLY if you've used:
resolved >= startOfMonth(-1)
However it will limit the issues ONLY by Feb 2018 if you will use:
resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-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.
Glad I could help. Please mark this solution as "Accepted" if it resolved your issue.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.