Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Create filter with relative date

Hello,

I would like to create a filtre using jsql with a relative date to get JIRA resolved within the last 30 days, something like :

- resolved>=now()-30

Any idea ?

Thanks

10 answers

1 accepted

30 votes
Answer accepted
Thomas Schlegel Community Leader Aug 02, 2012

Hi,

try this:

resolved > -30d

Cheers

Thomas

It works, thanks a lot :)

Like # people like this

Thanks. I was looking something similar. It works.

Like Gabriel Marcopulos likes this

Along the same lines, how can I create a filter for issues that have due dates between today and the next seven days, inclusive?

Radek Janata Community Leader Oct 12, 2017

@Chris Fouts

duedate > now() AND duedate < 7d
duedate > now() AND duedate < 7d AND resolution is EMPTY
Like # people like this

This is very useful. Is there a document/reference in JIRA that explains how to use this form? For example, can I use this form:

created < -1m AND duedate < 2y

You can't do that, Valid formats are:

  • 'yyyy/MM/dd HH:mm'
  • 'yyyy-MM-dd HH:mm'
  • 'yyyy/MM/dd'
  • 'yyyy-MM-dd' 

or a period format using w = weeks, d = days, h = hours, m = minutes

e.g. '-5d' or '4w 2d'.

Thanks to you all!! Very useful information!

You can also view only the recently updated issues, say in the last 4 weeks, in the following manner:

 updatedDate >= -4w

I am trying to create a filter for created vs resolved in 30 days   

is this correct ?

 (resolution = Unresolved OR resolution = Fixed) AND created > -30d AND resolved > -30d

Radek Janata Community Leader Nov 08, 2017

If you mean issues that are both created and resolved in last 30 days, then this is the simplest notation:

created > -30d AND resolved > -30d

Only issues with Resolution set are resolved. If resolution is empty, the issue does meet "resolved" condition.

Like robin_fielding likes this

This helped me out a lot, thanks very much.

Thanks it works now !

How can I create it with years? -3y doesn't work.

How about 36m?

Instead of now() I did sth like this:

project = Rec AND "App Date" < startOfDay(-3y)

Now it works great.

0 votes
Deleted user Oct 02, 2018

I am looking for a filter to pull issues created over 6 months ago.  I tried created > -180d, created >= -6m, created >= endofmonth(-5) and none of them seem to work.  

 

I also tried using createddate vs. created, but not getting the results I am looking for.  Any ides on how to create this filter?

Hi,

maybe this: created <=  endOfDay(-6M)

Deleted user Oct 03, 2018

created <=  endOfDay(-6M) didn't work, but by making a minor change to your suggestion, it worked.  I used created<=endOfDay(-180d).  Thank you so much for your help.

Sometimes it works with "M", sometimes with "d", I don't get it ;)

Hi,
It worked for me too.
I needed to perform a trigger that obtains issues that were in a same priority during a specific period of time and then, move them to higher priority.
Thanks a lot for all your help!
Cheers

resolved > -30d

Hi, i need a query to show the tickets created greater than 6 months and less than 1 year from now.

Thanks. 

created < -180d AND created > -365d

You need to use days "d" as "m" is reserved for minutes and "M" doesn't work. See also Advanced searching - fields reference in Atlassian Documentation.

How can I filter to see request created since 2018 till now. Please advise

Radek Janata Community Leader May 07, 2020
created > 2018-01-01

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you