Community
Q&A
Jira
Questions
Search for issues that were created on previous month

Search for issues that were created on previous month

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

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

15 votes

Answer accepted

You can try this:

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • livin-tpm likes this

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!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Search for issues that were created on previous month

1 answer

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events