Tracking of Custom Date Field (DueDate)

[Ashutosh Kulkarni]

Hi Experts,

I have a Custom field (DueDate) which is of Date Picker definition. This field is in screen where the user puts a Date initially and later changes based on the issue is Fixed or revised or iterations.

1. I want to know if there is any mechanism to find - How many time this Date was changed via a JQL or report or query of field mechanism ?

2. Secondly - this field is not a part of any workflow as such and used has access to field - still can we have a counter set to this field somehow and then query the counter based on NON-EMPTY or NON-ZERO.

3. Any other mechanism to find " How Many Times" this custom field " DueDate" was changed would be helpful.

[David Fischer]

You can also use the JMCF app and its Calculated (scripted) Number field with a formula like:

issue.getFieldHistory("DueDate").size()

[Ste Wright]

Hi @Ashutosh Kulkarni

There's no method via JQL to locate how many times a field was changed. You'd need to consider either:

• Querying the issue history via the REST API
• Use a script to count inside a hidden number field each time the field is edited - apps like ScriptRunner can achieve this

In regards to looking for due dates which are not empty - that can be done via JQL - eg.

DueDate is not empty

Ste