Issue Summary

The Assets custom field dropdown in the Jira Service Management portal takes up to 10 seconds to load options. This is due to the underlying Assets AQL query execution time, which cannot be reduced further with the current setup. The customer expects the dropdown to load within 3 seconds (99% of the time).

One of the reasons this happens is due to the number of Object Types included in the query (while using objectTypeAndChildren() function in Filter Scope AQL) 

Steps to Reproduce

1. Go to the Customer Portal or Jira Issue View which has an Assets Custom Field
2. Attempt to select a value in the Asset Custom Field which filters values based on another custom field
3. Observe the time taken for the dropdown options to appear.

Expected Results

The dropdown options for Asset Custom Field should load within 3 seconds (99% of the time).

Actual Results

The dropdown options take up to 10 seconds to load. In some cases (if the AQL execution exceeds 18 seconds), the field fails to load and returns a HTTP 500 error.

Workaround

Instead of using the drop-down if we paste the specific object lable in the respective field it will fetch the results quickly.