Need to automate scheduled review of assets with multiple attribute filters

[Steve Y]

I need to implement a monthly automation (on Data Center) that creates Tasks for assets that have not been reviewed in the past 2 years (giving them a 90 day window to complete). There are a total of three Attribute fields that comprise the logic for this IF command.

1. "Active" attribute is TRUE

2. "In Periodic Review" is FALSE

3. "Last Reviewed" is < 95 weeks ago

I've tried this in both Jira automation using "in aqlfunction("") format, using compound JQL query syntax, like this:

"Selections/s" in aqlFunction ("Active=TRUE") AND "Selections/s" in aqlFunction ("In Periodic Review=FAlSE") AND "Selections/s" in aqlFunction("Last Reviewed < now(-95w)")

and in Assets automation directly, using AQL.

objectType=Annex AND "Active" = TRUE AND "Last Reviewed" < now(-95w) AND "In Period Review" = FALSE

I can't get results from either.

I've built the query through the Basic builder in the Assets Object viewer, and it works just fine. When I put it into Automation, the automation runs, but it doesn't find anything. 

In addition to creating the issue, I'd also need to change the "In Periodic Review" attribute to TRUE, to prevent duplication of issue creation.

Any thoughts? I've hit a dead end. 

Thank you!

[Zamin Ali Panhwar]

O

[Zamin Ali Panhwar]

O

[Steve Y]

Hi Zamin,

What is the intent of your O comments? I'm not following. 

Thanks,

~Steve