nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

All comments

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!

Randy_dyxb6i

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

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!

Ionascu Irina

Hi @Randy ,

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jql

automation