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
Next: Root
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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I have a global automation rule for equipment stored in Assets that creates a ticket when the date of the next service is less than 30 days.
The part of the rule that is relevant is,
When an object is updated, For AQL - objectType = Equipment AND "next service - start date" < endOfMonth(30d)
This works when I test the AQL in Assets it filters the equipment that matches the query.
I am wondering if I can use the value of another attribute, in this case, "service frequency (days)" instead of endOfMonth(30d)?
If I enter this, it shows a green check mark but does not show the object:
objectType = Equipment AND "next service - start date" < "service frequency (days)"
What am I doing wrong?
Schema: corp assets
Object Type: Equipment
Object: sub-zero freezer
Attribute: next service - start date (type Date)
Attribute: service frequency (days)