Asset filtering

[Rose Antonette Paez]

Hi Everyone,

Send help.

So basically, I want to show the 10% & 15% in the customer form when the Name is selected from the first field. Here is the sample Asset that holds the 10% and 15%.

Here is the form I'm working on and the current set. 

I want to know the filter issue scope (AQL) that will target only the 10%&15% when the new installment amount has been selected.

Let me know if this is possible in JSM Cloud or not.

Thank you.

[Christos Markoulatos]

Hi @Rose Antonette Paez 

I believe you can do it using Assets custom fields with AQL in the Filter issue scope. You can dynamically filter the second field (10% & 15%) based on the first field’s selection.

Try this:

• Create two Assets object custom fields in your request type:
  • Field 1 → linked to your “Installment Amount” object type.
  • Field 2 → linked to your “Percentage” object type (where 10% and 15% live).
• In Field 2 configuration, set:
  • Filter scope (AQL):

objectType = "Percentage"

• • Filter issue scope (AQL):

object HAVING inboundReferences(objectType = "Installment" AND objectId IN (${customfield_XXXXX${0}}))

Replace customfield_XXXXX with the ID of Field 1.

• This ensures Field 2 only shows objects (10%, 15%) related to the selected Installment object.
• If you need to filter by label instead of objectId, you can use:

  objectType = "Percentage" AND Name IN (${customfield_XXXXX.label${0}})

• Add both fields to your portal form and test the dynamic filtering.

Links:

• Filter Assets field using another Assets field (Atlassian Support)
• Advanced AQL syntax

Let me know if it worked!