Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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. 

example.PNG

 

Thanks! 

2 answers

0 votes
Hana Kučerová Community Leader Jan 28, 2021

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...

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á Community Leader Jan 28, 2021

@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.

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á Community Leader Jan 30, 2021

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?

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

Hi @Randy Ho , 

 

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

example2.PNG

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you