Configure an Assets object custom field

You can configure the Assets object field to display specific objects in three (3) ways:

1. Object schema: Filter objects by schema.

2. Filter scope (AQL): Filter objects based on Assets information.

3. Filter work scope (AQL): Filter objects based on the current work item.

Object schema field

Use the Object schema field to select the schema linked to this objects field (required). If objects from a different schema are selected in the Filter Scope (AQL) field, only objects from that schema will be displayed.

Filter scope (AQL) field

Use the Filter scope (AQL) field to filter Assets objects based on information from Assets. This field is optional, and placeholders cannot be used.

For example, to display only certain laptop models from a specific manufacturer, you could enter the AQL query:
objectType = "Laptop" AND Manufacturer = "Apple".

Filter work scope (AQL) field

Use the Filter work scope (AQL) (formally Filter issue scope) field to filter data using information from the work item itself, such as other Assets object fields or Jira system fields.

This field includes validation – correct AQL syntax will be marked with a check, while incorrect statements will be marked with a cross.

This field is optional, and you can enable Display a default object in the customer portal to automatically display an object in the field.

Placeholders can be used in this field. Learn more about placeholders

Filter using another Assets object field

You can use the Filter work scope (AQL) field to reference another object field within the work item. This allows you to create a cascading list where the options in one list depend on the selection made in another.

For example, to display laptop models based on the manufacturer selected in another field, follow these steps:

1. Create an Assets object field named “Manufacturer” and set the Filter scope (AQL) to:
   objectType = “Manufacturer”

2. Create a second Assets object field named “Model” and set the Filter work scope (AQL) to:
   objectType = “Laptop” AND Manufacturer = ${customfield_xxxxx.label}
   where "xxxxx" is the custom field ID for the "Manufacturer" field.

This will make the “Model” field display only laptops corresponding to the selected manufacturer.

Filter using a system field

You can use the Filter work scope (AQL) field to reference system fields from within a work item, such as Assignee and Project.

For example, to show a list of laptops owned by the current Assignee, configure the Filter work scope (AQL) field with:
objectType = “Laptop” AND "Owner" LIKE ${assignee.label}
In this case, each laptop object would have an "Owner" attribute that matches the assignee's name in Jira.

Jira fields can hold either multiple values or a single value. You can refer to these values using the field's label or ID.

For example, if a custom field holds three (3) values: "bread", "bear", and "potato":

• (${customfield_1223.id${1}}) will return "bread".

• (${customfield_1223.id${3}}) will return "potato".

• (${customfield_1223.id${0}}) will return "bread", "bear", and "potato"

Use placeholders with multiple values

When a field holds multiple values, the placeholder can return either a single value or all values at once:

• To return a single value, use an index:

  • ${customfield_xxxxx.id${1}}

• To return all values at once, use a query like:

  • objectId IN (${customfield_xxxxx.id${0}})

  • or

  • Label IN (${customfield_xxxxx.label${0}})

In these examples, "xxxxx" represents the custom field ID (e.g., for the "Manufacturer" custom field).