Advanced Search Related Question

[Ashutosh Bhattacharya]

How do I use the search to filter out the tickets where a field has been changed?

Suppose I want to know the tickets where "Due Date" has been changed by someone.

[Anthony Morais]

Hi @Ashutosh Bhattacharya 

This app will suit you.

Install add the duedate field in the column and see the changes.

Hope it helps you!

Regards,

Anthony

[Craig Nodwell]

Hi @Ashutosh Bhattacharya welcome to the community.   JQL out of the box won't do that for you.  A rest call will but then you have to parse the JSON output.
Quick question do you have any scripting tool add-ons in your jira instance allowing you to get at the changehistory for the issue

[Tim Perrault]

Hello @Ashutosh Bhattacharya 

No. History searches do not support the 'duedate' field. The best you could do is search issues that were updated by a certain user, but that would bring back all the issues that were updated by that user.

• Find issues that were updated by John Smith:
  issuekey IN updatedBy(jsmith)
• Find issues that were updated by John Smith within the last 8 days:
issuekey IN updatedBy(jsmith, "-8d")

• Find issues updated between June and September 2018:
  issuekey IN updatedBy(jsmith, "2018/06/01", "2018/08/31")
  
• If you try to find issues updated in the last hour, like in the following example, the time will be rounded up to 1 day, as smaller values aren't supported:
issuekey IN updatedBy(jsmith, "-1h")

Closest I can get to what you need is

duedate IS NOT EMPTY and issuekey IN updatedBy(<someusername>)

There is a CHANGED Operator  that would work on some fields, but due date is not one of them.

The operator can be used only with the following fields: Assignee, Fix Version, Priority, Reporter, Resolution, and Status.

[Ashutosh Bhattacharya]

Hi @Tim Perrault thanks for your response however I think this would pull in any kind of update related to any of the issue fields. I'm particularly looking for people who are updating the Due Date field.

[Tim Perrault]

You will have to look in the marketplace to see if there is an app that can do it because you can't do history searches on the due date field.