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

[Ionascu Irina]

Hi! 

I am trying to do a Automation Rule in Jira to increment the Custom field B if the Custom field A (date type of field) is changed in the last 24h. But unfortunately I do not know any way of querying if the Custom field A has been modified in the last 24h...

As per the example I am showing here, my rule checks all the Bugs from the project every working day at 20:00 and increments Custom Field B. What I am missing in between is to add the IF condition, which would be "IF Custom Field A has changed in the last 24h". 

Does someone know how I can do this? I saw some discussions from 2013, 2018, 2019, but nothing more recently. 

Thanks! 

[Randy]

I havent tried this but maybe something like this:

fields:

<new> customfield_lastvalue

customfield_monitoredfield

customfield_counter

Scheduled Automation for Every 24 hours:

If customfield_lastvalue != customfield_monitoredfield

   customfield_counter++

   set customfield_lastvalue = customfield_monitoredfield

[Ionascu Irina]

Hi @Randy , 

Can you please detail where this rules should go? In "Additional fields"? 

[Hana Kučerová]

Hi @Ionascu Irina ,

wouldn't it be possible to use different trigger - Field value changed?

So every time your custom field A is changed, then immediately update the Custom field B or something like this...

[Ionascu Irina]

Hi @Hana Kučerová ,

No, unfortunately I don't have the PRO version... and with the basic version the "Field value changed" trigger is not enabled...

Thanks! 

[Hana Kučerová]

@Ionascu Irina I see :-(... please under which circumstances is your customfield A changed? Are your users able to change it whenever they want? I'm just trying to find some way how to mark the issue after the change to be able to use it in the condition.

[Ionascu Irina]

Hi @Hana Kučerová ,

The field is changed by the Project Manager when the project timeline changes, meaning that they have an epic with X tasks and/or bugs and those tasks can be postponed or need to be done earlier than agreed, so then the Custom field A will be changed.

So to answer your question, the PMs can modify that field in whatever moment, but they might not be the only ones doing it. 

Thanks! 

[Hana Kučerová]

Hi @Ionascu Irina ,

to be honest, I can't see any reliable way how to do it under such conditions, if Field value changed trigger is not available.

Are there any other applications with some sort of automation functionality available on your instance?