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

What is the JQL code for searching tickets created and due within 3 days?

Grace I'm New Here Oct 27, 2020

I'm looking to search for tickets created and due within 3 days, this is the code i currently have but it doesn't seem to fetch the correct tickets when I checked them. 

(created > startOfMonth() AND due <= 3d)

1 answer

1 vote
DPK J Community Leader Oct 27, 2020

@Grace Welcome to the community.

I haven't fully got hold your question but here are some queries to clarify,

1. Create in last 3 days from now and due in upcoming 3 days.

created >= -3d AND due <= 3d

2. Created in last 3 days from now and was due in last 3 days

created >= -3d AND due >= -3d

 

If you can clarify more in question I'll be happy to take a look at that again. 

Hi @DPK JThanks for your quick response! 

I’m looking for any tickets created and due in 3 days. Basically opened and closed in 3 days. We have a minimum turnaround time for tickets, so I’m looking for tickets that violate our policy. 

does that make sense? 

DPK J Community Leader Oct 28, 2020

I got it.

This is not straight forward with JQL. What you can do we have set time period and find issue that haven't been updated or for which status is not what you expect it to be. For example this, all issue that a not closed and haven't been updated for last 3 days.

status != Closed and updated < -3d

Suggest an answer

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

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

4,567 views 12 8
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