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

Need JQL to allow a filter to dsiplay changes only between 20 and 30 minutes of being actioned

I am trying to create a filter that will pick up only issues that are due to be actioned between 20 minutes from now and 10 minutes from now.

There is a date/time field defined that will have been populated with the actioning time (Planned Run Time) and I need the report to pick up only issues that are between 20 and 10 minutes prior to this time

I can get the first part to work

"Planned Run Time" >= -20m

But I thought adding the following would work and it doesn't

AND "Planned Run Time" <= -10m

 

So my full JQL was "Planned Run Time" >= -20m AND "Planned Run Time" <= -10m 

 

I cant use specific date/times in the JQL as I want to use these filters for subscription notification reporting (so subscribed users get an email with issues that are due to be actioned between 20 and 10 minutes time from the present)

 

What am I doing wrong?

 

Thanks

 

1 answer

0 votes

Hello,

You choose issues which already expired, If you want to choose issues, which are going to expire after 10 to 20 mins then your JQL query should be like this:

"Planned Run Time" >= 10m AND "Planned Run Time" <= 20m 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

4,490 views 5 15
Join discussion

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