JQL query on last update

[Revathi R K]

Is there a way to filter the issues whose Due Date field was not changed for 2 weeks or any specific time frame.

Please provide the jql query for any suggestions.

[Piet Pieters · Accepted solution]

Hey @Revathi R K , 

Welcome to the community! 

Sadly, history searches are only available for a few native jira fields, and duedate is not one of them. 

A more detailed explanation and a possible solution from an app vendor can be found here. 

You could create a workaround by using automation to set a date custom field (when duedate changes -> set custom date field x to now() ), then you can use JQL for that specific field. 

Hope this helps, 

Tessa

[Revathi R K]

<p>Thank you Tessa.</p>

<p>I have created the automation and trying to run the below query, but getting error.</p>

<p>project = &quot;Revathi Test Project&quot; AND &quot;Refinement Date[Date]&quot; Changed before &quot;2w&quot;</p>

<p></p>

<p></p>

<p>Error: History searches does not support Refinement Date.</p>

<p>Getting same error for other text field.</p>

[Piet Pieters]

Hey @Revathi R K

History searches are indeed not supported. 

However, since your refinement date is a date field, you don't need the history. 

If you set the refinement date to now() when editing the duedate field, you can work with that date directly.

If you want to check if the duedate field was edited 2 days ago, you can query "Refinement date" = - 2d (because you would have set it to the current date 2 days ago)

Hope this clears it up! 

[Revathi R K]

Thank you Tessa

[Piet Pieters]

Hi @Revathi R K , 

Great to hear you got it working! 

Please remember to accept helpfull answers. This way, users with the same problem searching for a solution can find it faster. :) 

Have a great day! 

- Tessa