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

Search for issues that were created on previous month

Christophe NOVA1

I would like to know how to refer to previous month in a HQL Jira. For exemple,

JIRA bug open on the previous month

for exemple, in january, I untersdood the HQLwas :

project = XXX AND issuetype = Bug AND created >= 2013-12-01 AND created <= 2013-12-31

but, each month, i can modify the request, for exemple, in feb., i will write :

project = XXX AND issuetype = Bug AND created >= 2014-01-01 AND created <= 2014-01-31

what is the solution for to have a generic request for to have bug open the calendar on previous month, not to have bug for relative day (created > "-31d") or fixed date (created >= 2014-01-01) !

thank you for your help

Regards

Accepted answers

Jobin Kuruvilla [Adaptavist]

You can try this:

project = XXX AND issuetype = Bug AND created &gt;= startOfMonth(-1) AND created &lt;= endOfMonth(-1)

All comments

Jobin Kuruvilla [Adaptavist]

You can try this:

project = XXX AND issuetype = Bug AND created &gt;= startOfMonth(-1) AND created &lt;= endOfMonth(-1)

Christophe NOVA1

I try and it's OK ! thank you very much for your help !

Is there any documentation with standard function which is possible to use in JIRA HQL, such as startOfMonth ?

Regards

Jobin Kuruvilla [Adaptavist]

It is JQL, not HQL Here is the documentation: https://confluence.atlassian.com/display/JIRA/Advanced+Searching

Bruce von Kugelgen

Great tip--it's easy to forget that those functions like startOfMonth() can accept parameters–the Atlassian documentation doesn't make that clear (to me).

Welcome!

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

Quick Links

Find more posts tagged with

jira