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.  

[Ilya Turov · Accepted solution]

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

[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!

[Andrew Mirauta]

Hello @Ilya Turov , is there a startOfYear type function for the previous year? I'm loving this function, and I'd like to add a 2020Q1 report next to it for comparison. I'm seeing this as being used for the next few years at my company's board meetings. 

[Thomas Deiler]

Dear @venmathi sivasankaran ,

what about pragmatically:

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

for Q1?

So long

Thomas

[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