How to use AQL placeholder to show options in Assets field B based on the value selected in Assets field A

Summary

You can use an AQL(Asset Query Language) placeholder to list options in an Assets field based on the value selected in another Assets field.

For example, let's say we have 2 fields called Customer and Phone. On updating the Customer field, we want to pre-populate the value for Phone.

Solution

In order to achieve this requirement, for the Customer custom field, we will be using the usual AQL, but for the Phone custom field we will refer to the Customer custom field as a placeholder.

On the Filter issue scope (AQL) for the Phone field, use an AQL like:

• Filter scope (AQL): objectType = "Phone"

• Filter issue scope (AQL): Customer = ${customfield_10123}

Be sure to replace the field ID with the correct ID for your field.