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!
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
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.
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
Kagithla Babu Anvesh
Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events