• Products
  • Get started
  • Documentation
  • Resources

Assets JQL Functions

Assets in Jira Service Management is a Premium and Enterprise only feature. Learn more about Assets.

Assets supports a specific JQL function called aqlFunction, which allows you to query issues containing an Assets object custom field, using Assets Query Language (AQL). This allows you to further filter issue results based on the Assets database (e.g. attributes of Assets objects).

More details on how AQL is constructed can be found here.

aqlFunction(aql)

Syntax

1 aqlFunction(aql)

Supported fields

Assets object custom field

Supported operators

IS, IS NOT, IN, NOT IN

Examples

In the following JQL examples, we’ve used a field called customField to represent an Assets object custom field (the name of the field is defined by the Jira admin).

  • Find issues where a website is reported and where the customer account manager is Mathias Edblom:
    customField in aqlFunction("Customer.\"Account Manager\" = \"Mathias Edblom\"")

  • Find issues where an application is reported and where the application is installed on a virtual server:
    customField in aqlFunction("Host.Virtual = true")

Using the AQL function with an object schema or specifying an object type in the AQL will significantly increase performance. If the AQL function is used when calculating JSM SLA's for instance, try to limit the AQL by adding object type name, schema id or object key as this will decrease the execution time of the query.

 

Still need help?

The Atlassian Community is here for you.