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

Need to automate scheduled review of assets with multiple attribute filters

Steve Y August 29, 2024

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!

1 answer

0 votes
Zamin Ali Panhwar
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!
September 19, 2024

O

 

Zamin Ali Panhwar
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!
September 19, 2024

O

Steve Y September 25, 2024

Hi Zamin,

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

Thanks,

~Steve

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events