Hi community, I am trying to churn a report using JQL filter that displayed monthly ticket assigned to particular person in a year.
I am really confused regarding the usage of StartofYear() and EndofYear()
Since we only started using JIRA in November, below query should return data for the month of November (11M) but I am not sure why, the query below is not returning any data...
after startofyear("+11M") before endofyear("+11M")
From what I understand, the above query should return data from Starting of November to end of November right?
Hi @Jeff Boon,
I would suggest 2 small adjustments. To start from November, just add 10 months instead of 11 and leave out the "+" as this is a reserved character.
> startOfYear(10M) and < endOfYear(10M)
For now, you can of course just leave out the < endOfYear(10M) part, as we're not there yet.
Hope this helps!
Ah yes, I think I misunderstood the meaning of 11M, I thought the 11M is meaning November but instead it is supposed to add 11 Months. Thank you for your answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Walter Buggenhout , Any reason why the query below also returned November data?
after startofyear(9M) before endofyear(9M)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Because startofyear and endofyear do what they say - they give you the start and end of the year. not a month within a year.
I suspect you should be using "after startofmonth(9M) before endofmonth(9M)" if you only want to see data for a particular month
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Jeff Boon
If you want to know the tickets crated in November/current this month use this below.
created >= 2021-11-01 AND created <= 2021-11-30 order by created DESC
The above will display all the issues created from 1st November to 30th of this November.
Another way
createdDate >= startOfMonth() and createdDate <= endOfMonth()
if you are completely new to JQL please shift to BASIC while searching the issues please follow the below
Menu -> Filters -> Advanced issues search
You can customize something like this
Thanks,
Kagithla Babu Anvesh
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.