Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

AQL Date Attribute Query

Dustin Alcock
Contributor
June 6, 2023

In Assets I've built out a Software Catalog. One of the attributes is "Last Access Audit" as a Date type value. I'm attempting to setup a global automation that runs daily and will look for any software objects with a Last Access Audit value greater than 180 days.

"Last Access Audit" is EMPTY
Works on all objects where the field is empty. No issues with this.

"Last Access Audit" >= -3d
No results found after putting in a date several months old. Simplifying by looking for older than 3 days instead of 180 to start out. I've also tried just =

LAA-1.PNG LAA-2.PNG

1 answer

1 vote
Mikael Sandberg
Community Champion
June 6, 2023

AQL does not have the same functions for dates as JQL, but if you use this it should work:

"Last Access Audit" < now(-180d)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events