JQL Convert StartofMOnth() to Month Name

Patrick Hicks November 10, 2023

Would like to create a JQL, that would find the issues within a fixVersion that is named for the current month release.  


     fixVersion ~ startOfMonth() 

   or 

     fixVersion ~ Now(format(dd/MMM/yy))

The naming convention of the fixVersion is "dd/MMM/yyyy Release" e.g"01/OCT/2023 Release"
 

I would like to use this query for a filter to surface the results to a dashboard gadget, so that the dashboard would only show the issue related to the current month's release.

 

1 answer

1 accepted

3 votes
Answer accepted
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 10, 2023

Hi @Patrick Hicks 

First of all, I don't think you can do that with fixVersion. As per documentation, fix version can be compared with a string and not with a function, which returns a date field.

What you could possibly do is to parse the fixVersion name and only the date part, copy it to a custom date field and then use that date field with the startOfMonth() function. It could work.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events