nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to filter all current year issue and previous month

serge calderara

Dear all,

I try to build to build a filter which is suppose to return all issue from current year 2021.

For doing so, I add to the end of my Jql script the following created >= -365d

But this return records which has been also created in 2020, what I am doing wrong ?

Thanks for help

regards

Accepted answers

Mohamed Benziane

Hello @serge calderara

If you want to retrieve all issue of the current year you can use this :

created >= startOfYear()

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearching-functionsreference-startOfYearstartOfYear()

KAGITHALA BABU ANVESH_z1zl10

createdDate >= startOfYear()

Nic Brough -Adaptavist-

Your JQL is looking for "date larger than or equal to 365 days ago", it's not looking at calendar years.

You should look to the calendar functions, start of/end of, day, week, month and year.

For this one, I think I'd use

created > startOfYear()

(If you wanted to include last year, you'd use "created > startOfYear(-1)" )

All comments

Mohamed Benziane

Hello @serge calderara

If you want to retrieve all issue of the current year you can use this :

created >= startOfYear()

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearching-functionsreference-startOfYearstartOfYear()

KAGITHALA BABU ANVESH_z1zl10

createdDate >= startOfYear()

Nic Brough -Adaptavist-

Your JQL is looking for "date larger than or equal to 365 days ago", it's not looking at calendar years.

You should look to the calendar functions, start of/end of, day, week, month and year.

For this one, I think I'd use

created > startOfYear()

(If you wanted to include last year, you'd use "created > startOfYear(-1)" )

serge calderara

hello @Mohamed Benziane , thanks that works.

by the way if I need to retrive issue from previous month what will be the syntax ?

Let say that if current month is february, I would like the filter of only month january.

is tehre any prevMonthofYear() ?

regards

Mohamed Benziane

You can use the startOfMonth() function.

This one should work for you :

startofmonth(-1)

In your scenario if you want to go back until December you will replace "-1" by "-2" and so on.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearching-functionsreference-startOfMonthstartOfMonth()

serge calderara

perfect thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

atl-gruland