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

IQL statement to trigger email when a value changes

Charles Granberry December 10, 2021

I am trying to use the Automation to send an email notification when a value changes for an object.  Specifically when an asset is transferred to another location.

Looking at the IQL documentation and so far nothing is jumping out as a search for when something was changed for a specific attritbute.

Any help would be greatly appreciated.

2 answers

0 votes
Charles Granberry December 12, 2021

Found it:

"Site" IN ("Site 1","Site 2","Site 3","etc") AND “Updated" <= now() AND "Updated" > now(-3h)

Charles Granberry December 12, 2021

This is not finding what I thought it is.   am looking for it to find only  objects were the the attribute 'Site' is changed.  This IQL is finding all objects that have ANY attribute updated 

0 votes
Charles Granberry December 10, 2021

ObjectType = 'Site' Updated > "now(-2h 15m)" 

Had the green check mark until I ran it.

Error: IQL "'objectTYPE = 'Site' Updated > "now(-2h 15m)"" has invalid syntax at position 21 with error message "mismatched input 'U' expecting {<EOF>, ' '}"

 

Position 21 is right at the beginning of 'Update'.

Now that I think about it, 'Site' is not an object type but an attribute.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events