Query to check when 'end date' was changed

[johnnav]

I am trying to write a query of -

1. Get a list of stories/tasks whose 'end date' has been changed

2. Number of times the 'end date' was changed

[Yuliia_Borivets__SaaSJet_]

Hi @johnnav 

Another solution, you can check if you're comfortable with Marketplace plugins, is Issue History. My team has created it to get a list of every update made to the tasks. You can filter by dates and add any issue field as a column. 

Here is an example:

Let me know if it helps.

[Srikanth Upputuri]

You can take a look at the below articles.

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Tracking-of-Custom-Date-Field-DueDate/qaq-p/1195983

https://community.atlassian.com/t5/Jira-Core-Server-questions/Tracking-due-date-history-in-a-text-field-using-behaviors-in/qaq-p/1686806

[Vishwas]

Hey @johnnav 

1. Unfortunately history searches are not supported on custom fields so we cannot be able to do so with JQL out of the box.

2. For second one also we cant get via JQL.

but via API we can to get this.

Regards,

Vishwas

[johnnav]

Thanks Vishwas. Is there a good reference site for the usage of the APIs?

[Vishwas]

Hey @johnnav 

Are you on Jira Server or Cloud Variant ?

Regards,

Vishwas

[Vishwas]

Hey @johnnav 

For Jira Server this is the API we have use : https://docs.atlassian.com/software/jira/docs/api/8.20.1/com/atlassian/jira/issue/changehistory/ChangeHistoryManager.html#getChangeItemsForField-com.atlassian.jira.issue.Issue-java.lang.String-

For Jira Cloud this API : https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-get

Check out this article here it might help https://www.ravisagar.in/videos/jira-rest-api-change-history-who-made-change

Regards,

Vishwas