JQL for specific months

Question

So... I think to the answer to this question is "No, not without an add-on" but I'm going to ask anyway!

We use our service desk to log audit tickets and these tickets are categorised into Quarter 1/2/3/4 (IE Jan-Mar, Apri-Jun etc) using a cascading dropdown in the form of Audit > Q1

What I want to do is automatically categorise the ticket into Q/1/2/3/4 depending on the month in which it was created. I can't seem to use the createdDate >= because that requires me to put in the "Year" which I don't want, because it needs to do this regardless of the year.

So basically, if it was created in the month of June, it should automatically categorise it to Q2

Thanks!

Liam Green · Answer

Hi Asher

We are indeed on two different tickets - I'd noticed this the other day!

I'm pretty confident the above should work but do let me know.

Thanks, Liam

Asher Francis · Answer

Hi Liam

Only just seen this - and we seem to be communicating on two separate questions!

I'll try this and let you know how I get on

Thanks

Martin Bayer _MoroSystems_ s_r_o__ · Answer

I do not have much experience with it but I tried automation rules for your usecase and it looks like it's working.

I tried to create new rule for "Issue created" and implemented two conditions (you will need 12, each for each month). Each condition is followed by "edit issue" action.

Cconfiguration of condition is:

And "edit issue":

You can see I added new custom field Quarter of single select type with values Q1, Q2, Q3, Q4. You can filter easily on this field.

I hope it will help.