AQL for Assets Cloud

[Rudy Hemkes]

I am running Jira Service Management (Cloud) and I want to create a rule that checks a date field in an Assets object and alerts when the date has expired.  I was under the impression that AQL was the automation I should use but I can't seem to find it.  Is AQL available for JSM Cloud?  If not is there to build an automation in JQL?

[Zoey Wang]

Hi @Rudy Hemkes 

AQL can help with querying relevant objects for certain purposes in Asset. I can see the production plan you are in is Premium. So you should have access to the Asset feature. 

Here are the steps to find AQL tab

1. Select Assets in the top navigation bar.

2. Select an object schema from the list.

3. Select an object type.

4. Select Objects mode.

5. Select the icon (in List view) or the Filter icon (in Detail view).

6. Select the Advanced AQL tab.

7. Enter your AQL query.

8. Select Update filter. The results of the query will be pre-filtered by the currently selected object type.

Having said that, the automation rule might be setup by using Scheduled trigger on certain frequency, then lookup certain objects for the date attribute for instance against expiry dates. That can lead to a notification action as an alert to stakeholders. 

Further questions please call out.