Equipment maintenance automation with Assets AQL

JuanC
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 11, 2022

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)

 

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events