The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help on search option

Kamal Dhingra
August 17, 2020

Hi,

How to search for the tickets which have a due date prior to their creation date. (incorrect due date set by mistake )

Thank you!!   

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Jack Brickey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 17, 2020

you will need an addon e.g. Scriptrunner or similar. With SR you can use the following I think...

issueFunction in dateCompare("", "duedate" < "created")

Actually you could also use Automation for this. Here is an article that might help - calculating-the-difference-between-two-dates 

Kamal Dhingra
August 17, 2020

Thank you Jack!!

Actually I was looking for something in JQL to fix this.

I am new to JIRA, let me try this.

Jack Brickey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 17, 2020

You cannot achieve this with JQL.

0 votes
Jira Guru
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 17, 2020

Try this

 

due < created

Kamal Dhingra
August 17, 2020

Thank you Guruvayrappan G R

It did not work as it threw an error

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events