Query to detect changes in a Custom field in the last 24h

[Marc]

Hello all,

I would like to create a filter to display the issues where one of their custom fields has been updated in the last 24h.

I have checked the JQL possible options, as well as the Script JQL Functions provided by groovyrunner, but I havn't been able to find out how to perform it.

Does anybody have any clue on how to implement it?

Thanks in advance.

Marc

[JamieA · Accepted solution]

You mean any of their custom fields, or one in particular?

Anyway, you need the custom field to support the "changed" operator, and none of them do atm. You could write your own function that either queried the database, or visited each issue and checked the API, but that would be slow.

The only way to make it perform adequately is index the changes, which is what fields that support the "changed" operator do.

Visiting each issue is not so bad actually if you only do that on issues "updated > -1d".

[Marc]

Hello Jamie,

Thanks for your quick advice!

It would be one single CF.

We had arrived to a similar conclusion. The main drawback here is the performance degradation, because this query would be saved as a filter and added to a Dashboard, so the query would be performed periodically every time the dashboard is reloaded.

I will consider the option "updated > -1d".

Regards,

Marc

[Alex V]

Hi guys, it's 2018 and custom fields still do not support "Changed".

So I don't have to reinvent the wheel (or learn sql), can you share your queries? And perhaps some general advice about working in the trenches of JIRA.

[Daniel Di Martino]

I'm after this detail as well!

[K_Daniels]

Looking for a solution to this as well.

[Jenny Severin]

I need a filter for changes made to a custom field too!