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

Want to create JIRA fliter that filters the tickets created in any specific quarter (Q1/Q2/Q3)

venmathi sivasankaran

Hi I want to filter the JIRA tickets based on the date it has been created. But I want to filter for each Quarter. Q1 Q2 and Q3 that way... I tried using the below query. But it doesn't seem to work properly.

Query 1: project = RFL AND (created >= startOfYear(7M) AND created <= startOfYear(9M))

Query 2: project = RFL AND created >= startOfMonth()

Query 1 is for filtering tickets for this Quarter (Q3) but no results are returned. Where as Query 2 is returning me results which are created starting from this month .

If I try to use the Query 1 for last quarter(Q2) I'm getting some results. But I doubt whether its correct as its is not working for Q3.

Please help me out.

Accepted answers

Ilya Turov

it's just that startOfYear() is the 1st of Jan, startOfYear(1M) is the 1st of Feb etc.. so startOfYear(7M) gonna be 7 months after the year started, so the 1st of August, which as we all know hasn't come yet

All comments

Thomas Deiler_db00h3

Dear @venmathi sivasankaran ,

what about pragmatically:

project = xyz and createdDate >= 2019-01-01 and createdDate < 2019-04-01

for Q1?

So long

Thomas

Ilya Turov

venmathi sivasankaran

Hi @Thomas Deiler

We can use dates, but I'm thinking of some generic stuffs , so that we no need to change the dates all the time. But Thank You for input and time.

Thanks,

Venmathi

venmathi sivasankaran

Thank You @Ilya Turov

Its bit confusing. So the below query returns tickets created in Q2.

project = RCTRL AND (created >= startOfYear(3M) AND created <=endOfYear(-6M))

Ilya Turov

Honestly, I would go for consistency and use startOfYear() (almost) everywhere, so

Q1: between startOfYear() and startOfYear(3M)

Q2: between startOfYear(3M) and startOfYear(6M)

Q3: between startOfYear(6M) and startOfYear(9M)

Q4: between startOfYear(9M) and endOfYear()

venmathi sivasankaran

Yes This works. I'm confusing myself a lot. Thank You IIya!

Welcome!

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

Quick Links

Find more posts tagged with

confluence

jira-core