Need help on search option

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

0 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you Jack!!

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

I am new to JIRA, let me try this.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

You cannot achieve this with JQL.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

Try this

due < created

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you Guruvayrappan G R

It did not work as it threw an error

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.