Need help building a filtered picklist in portal form, using custom field and JSM Assets

[Gina Daniels]

Hi everyone,

I’m working in Jira Service Management (JSM) with Assets and looking for guidance on building a filtered application picklist in a portal form.

I have an Assets object type called “Application Name” & "Agency Name 

• Application Name (used as the display/label)
• Agency ( also a display/label used reference to an Agency object)

In my JSM portal, I’ve created a dropdown for users to select an Agency (e.g., EEC, DHE, etc.). Based on that selection, I want to display a filtered list of Application Names associated with the selected agency.

I’m using separate Assets custom fields per section and attempting to filter via AQL.

Question:
What is the correct AQL syntax to filter the Application Name object type so that only applications associated with a specific agency (e.g., EOE) are returned in the dropdown?

For example, I’ve tried variations like:

objectType = "Application Name" AND "Agency" = "EEC"

and
objectType = "Application Name" AND "Agency"."Name" = "EEC"

I do not get results,  I only get results when using the App Name only i.e. 
ObjectType = "Application Name" 

I can not get the Agency to display.
Any guidance on the correct AQL structure—especially when the Agency attribute is a referenced object—would be greatly appreciated.

Thanks in advance!

[Andrea Robbins]

If the attribute "Agency" is on the Application Name object type, you can do this in the issue filter scope for the application names field: 

"Agency" = ${customfield_id}

Where customfield_id is the id of the application name custom field

If "Agency" custom field is multi-select, edit it slightly by doing this:

"Agency" = ${customfield_id${0}}

You can keep the "objectType = Application Name" part in the first line (filter scope) but not within issue scope.