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

JQL - get current month automatically

Dana.Harel

Hi,

I'm building automation that will create each month a new issue.

I would like for the issue's summary to contain the name of the current month we are in.

How can I do it using JQL?

Thanks

Accepted answers

Nic Brough -Adaptavist-

JQL finds issues, not dates, so, no, you can't do this with JQL. You'll need to write something that can get the month name as part of your "create" script/program

Bill Sheboy

Hi @Dana.Harel

I am guessing your rule uses the scheduled trigger to create the new, monthly issue.

If so, please take a look at the date time functions for smart values, and the documentation on the format() function: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

With that, you may format the value of {{now}} to be the name of the current month.

Kind regards,
Bill

All comments

Dana.Harel

Can I use "getMonth()" or one of - endOfWeek, endOfMonth, and endOfYear; and startOfDay, startOfWeek, startOfMonth, and startOfYear?

Nic Brough -Adaptavist-

JQL finds issues, not dates, so, no, you can't do this with JQL. You'll need to write something that can get the month name as part of your "create" script/program

Dana.Harel

Thanks - where should I write something like this?

Bill Sheboy

Hi @Dana.Harel

I am guessing your rule uses the scheduled trigger to create the new, monthly issue.

With that, you may format the value of {{now}} to be the name of the current month.

Kind regards,
Bill

Dana.Harel

Hi @Bill Sheboy thanks!

I am using the scheduled trigger to create new monthly issue.

My wish is that for each issue - the summary will contain the current month's name -
For example "Monthly task - December"

I tried using the documentation attached but it seems like all I can get is the full date.

I tried using:

{{issue.created.format("dd/MM/yyyy")}}
{{now.startOfMonth}}

Will you be able to advise?

Thanks

Bill Sheboy

That link I provided shows the format() function, and a link out to the examples for the format strings. Here is one to return the full month name for the current date:

Dana.Harel

Thanks is worked!!

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud