Search for issues that were created on previous month

[Christophe NOVARRO]

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

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

You can try this:

project = XXX AND issuetype = Bug AND created >= startOfMonth(-1) AND created <= endOfMonth(-1)

[Christophe NOVARRO]

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).

[Chris Wallingford]

I'm on Cloud Confluence ... can this be done in a Confluence Search URL? My trail and error has only led to error.... Eg.

https://abcd.atlassian.net/wiki/dosearchsite.action?cql=space+%3D+"abcd"+and+lastmodified+<%3D+startOfMonth%28-12M%29+and+type+%3D+"page"

Thanks!