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)
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.