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 birthday current month

Dante Labate

Community...

I am using an instance of JIRA to manage the registration of people supported by an NGO that helps people who are going through needs.

One of the custom fields that creates the date picker type and is populated with the date of birth.

I'm trying to create a JQL query and list the problem that has the birthday date for the current month, but I'm not getting ...

Can someone help me?

project = cb and "date of birth" >= startOfMonth() and "date of birth" < endOfMonth(1)

Accepted answers

All comments

Matt Doar_tzgiej

ONG: Abbreviation in French, Italian, Spanish, Romanian and Portuguese for non-governmental organization (NGO in English)

Perhaps:

project = cb and "date of birth" >= startOfMonth() and "date of birth" < endOfMonth(1)

Dante Labate

Tanks Matt,

Sorry, I was wrong to enter information, I already tested that way and it does not work, it seems that it is also taking the year into consideration

Dante Labate

I made some changes to the original question.

Does anyone have any ideas?

Nic Brough -Adaptavist-

I think you'd need to code a JQL function to do this, or code a scripted field that pulled the month out separately.

The problem for you with the start and end functions you have tried to use is they really do mean "the current month" (or +/- x months), and they look at the whole date. April last year won't be returned in start/end because it was last year.

Dante Labate

I realized this but as the startyear function exists, I thought it would look exclusively for the month.

I also own the scriptrunner, could you help me with this script that isolates me only the month of this date field?

Nic Brough -Adaptavist-

Ah, well that makes it easy. I'm not so hot on JQL functions. or even coding, but a scripted field will do the job:

import com.atlassian.jira.issue.Issue<br>import com.atlassian.jira.component.ComponentAccessor<br>def customFieldManager = ComponentAccessor.getCustomFieldManager()<br>def birthdayField = customFieldManager.getCustomFieldObjects(issue).find {it.name == "Birtday field name"}<br>return issue.getCustomFieldValue(birthdayField).getMonth()<br>

This assumes the field is always filled, and you want a 1-12 number back from the date.