Jira query for current Month/Year

[Bernard A]

We are building out dashboards for Install Notifications for our users - the dashboards would be viewed on the monthly basis, and would display items that are being installed in the current month. The thing is, we don't want to maintain it manually, and we are trying to figure out a way in which, when you are for example viewing the dashboard in September, it would only display September items. I know that we can utilize start_date/end_date and other date fields, but we dont' want to make users populate them when creating these tickets. Within our query for the dashboard, we are looking to include a clause that would give us results based on the current month/year, since our FixVersion has dates in that format (for example, 'September 2023'). Would it be possible to build a query that would look at FixVersion and if the date within that field matches the current Month/Year, it would give us results?

[Florian Bonniec]

Hi

You could get around using earliestUnreleasedVersion() if you manage porperly the versions in your project.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearchingfunctionsreference-earliestUnreleasedVersionearliestUnreleasedVersion()

If you have Scriptrunner you could use on of the function.

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/versions

Regards