You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am looking for a way to grab and report on all issues that have had a field value change in the last day. JIRA doesn't allow for the "Changed" operator to be used against custom fields. Project automation has a "Scheduled" trigger and a "Value Changed" trigger but I can't have them both go off. Basically I want:
At 7pm everyday, send an e-mail out for all issues that have had "X and "Y" value changed in the last day. I was attempting the following inside project automation:
When Field Value Changed
IF issue is in JQL (updated >= startofDay(-1d)
Any thoughts on a good way this can be done with project automation that maybe I'm just missing?
Perhaps using Entity Properties on each Issue of interest would help. I haven't tried this, but it might be worth exploring.
The key concept would be to store the "old values" for an Issue in one (or more) Entity Properties on that Issue. Then you can compare those old values to the current values.
Your rule running once per day would first compare the old and current values and generate the email. The rule would also clear those Entity properties after use.
_ _ _ _ _ _ _
If you don't need the old values in the email, an alternate approach would be to use the Entity Property as a simple flag indicating that a value changed. Then you could have one rule trigger when those values change, and that rule would just "set the flag" in an Entity Property on that Issue. Then your daily rule would inspect all the Entity Properties and generate the email based on the "set flag values" in the Entity Properties, and then clear the flag.
I don't believe searching for Entity Property is natively supported in JQL (maybe via certain add-ons?). But you could iterate on all Issues changed in the last day and check Entity Properties on each.
The first mistake would be the trigger, according with what you're saying it should be a CRON expression: 0 0 19 * * * (19h, 0m, 0s, everyday).
The most pressing problem is that, like you say, the CHANGED operator is not supported with custom fields. This means that you can't search for an update just in those X and Y fields. Updated will include any update in any field, status, comments, etc.
Maybe you could design a workaround based in the verynature of your process... Let's say that those X and Y fields start empty and once they have a value they don't change. You could search for updated >= startOdDay(-1) AND customField_X is not EMPTY and customField_Y is not EMPTY.
Of course you'll be able to think of a better option for a workaround since you have a much deeper knowledge of your particular workflow.
I hope it helps somehow. Maybe I'm missing something and it can be done so let's hope someone else can chip in :)