How to use Asset Query Language syntax?

Assets Query Language (AQL) is a language format used in Assets in Jira Service Management to create search queries for one or more objects.

Basic syntax

The basic syntax of an AQL query is <attribute> <operator> <value/function>. The query returns one or more objects when the attributes of these objects match the operator and value specified.

To know more about Assets Query Language, refer to

Example

Query

Example

Query

Limit the search result to a specific object schema name.

objectSchema = "ITSM Schema"

Limit the search result on object schema ids.

objectSchemaId in (1, 2)

Limit the search result to a specific object type.

objectType = "Employment Start Date"

Limit the search result on object type ids.

Search all attributes on all objects for a relevant match.

Limit the search to the object having any inbound references to it.

Find an object by object Id.

AQL syntax validation

The Assets app manages the AQL syntax validation and error messages.

Once you provide an AQL query, to validate the syntax, click Validate AQL Syntax.

If you skip manually validating the AQL syntax, the form validation is performed with the click of Continue.

  • If the AQL syntax is correct, then is displayed.

  • If the AQL syntax is not correct, an error message is displayed. To proceed to the next step, provide valid AQL query syntax.

A few error messages are listed below based on the type of syntax errors.

Example

Query provided with invalid syntax

Error message

Example

Query provided with invalid syntax

Error message

Limit the search result to a specific object schema name.

Limit the search result on object schema ids.

Limit the search result to a specific object type.