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; } } }

Filters - Advance issue search - JQL

Shabbir Hassan_0vy3jl

I was wondering if anyone had a piece of JQL which can help me with the following. Any help will be greatly appreciated.

Tickets carried forward into month

A piece of JQL I can add which will show me Jira tickets which were created before the first of the month but were closed and open on or after the first of the month . So for example tickets which were created before the 1st of November but were closed and still open on or after the 1st of November.

Outstanding tickets

A piece of JQL which will show all tickets which were open for a specific date. For example if I'm on the 13th of December and I wanted to know outstanding tickets for the 1st of December.

Accepted answers

Trudy P Claspill

Hello @Shabbir Hassan

Welcome to the community.

For tickets that carried forward into the month:

There is not a built in time stamp for the Closed Date for issues, but there is one for the Resolution Date, which is often the same thing. You could use this filter

createdDate < startOfMonth() and (resolutiondate is empty or resolutiondate >= startOfMonth()) order by created DESC

All comments

Trudy P Claspill

Hello @Shabbir Hassan

Welcome to the community.

For tickets that carried forward into the month:

There is not a built in time stamp for the Closed Date for issues, but there is one for the Resolution Date, which is often the same thing. You could use this filter

createdDate < startOfMonth() and (resolutiondate is empty or resolutiondate >= startOfMonth()) order by created DESC

Shabbir Hassan_0vy3jl

@Trudy P Claspill many thanks, that's my carried forward filters sorted

Trudy P Claspill

For your second filter the filter would be

createdDate =< "2021-12-01" AND resolved >= "2021-12-01"

Shabbir Hassan_0vy3jl

Many thanks @Trudy P Claspill for your help. I managed to find this one too which works well for me.

created < 2021-12-01 AND (resolution = Unresolved OR resolved >= 2021-12-01)

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud