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
You can try this:
project = XXX AND issuetype = Bug AND created >= startOfMonth(-1) AND created <= endOfMonth(-1)
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.
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.
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.
I'm on Cloud Confluence ... can this be done in a Confluence Search URL? My trail and error has only led to error.... Eg.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.