Forums

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

How to find the task with the particular duedate

Nadya Domracheva June 12, 2022

Hello everyone!

I am trying to find issues/tasks such that the difference between the established due date and createdDate was no more than 2 or 3 days. Tested stuff like this:


due = createdDate + 2d

Unfortunately, it is not working. Could you help me with that? 

Thanks a lot.

2 answers

2 accepted

4 votes
Answer accepted
Bill Sheboy
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 Leaders.
June 12, 2022

Hi @Nadya Domracheva -- Welcome to the Atlassian Community!

You cannot compare different issue fields with out-of-the-box Jira Cloud features.  Specifically, JQL is not a SQL and so does not have such features.

Some possible work-arounds to solve this use case depend upon how often you want to do this and how much money/effort you want to spend/invest.  For example:

  • need this one time
    • Try exporting your issues to a spreadsheet and perform the data comparison there
  • need this often, and got lots of money to spend
    • Take a look at the Atlassian Marketplace for JQL or reporting addons which support comparing fields and/or performing math on them to create calculated fields
  • need this often, and do not want to purchase an addon app, and willing to learn about automation rules
    • Use an automation rule to detect and report on this condition.  This could be triggered as a scheduled rule (e.g. every day) or whenever the fields change, storing the difference in a new custom field.  That custom field could then be searched using the built-in JQL.

Kind regards,
Bill

Nadya Domracheva June 12, 2022

Hi Bill, thank you so much for your suggestions. I think I'll realize the last one about the automation notification. Thanks a lot

Like Bill Sheboy likes this
Nadya Domracheva June 12, 2022

Thank you!

Like Ollie Guan likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events