Filtering the values in an Asset field based on another non-Asset custom select field

Zeeshan Khan

I have a custom field "Field A" that is a single user picker field and shows users filtered on Active Directory security groups. Field Id is customfield_10373. Screenshot below:

 

Now I have created another Asset field called "Field B" in my People schema and referenced by "Employees" object and its fetching all the employee names etc. when used in a form. I want "Field B" to show filtered users like the ones shown in Field A and not all the employees when a user types in a user name in the field. How can I do that?

Tried doing this below but didn't work.

Andrea Robbins

Hello,

Hate to be the bearer of bad news but this is not possible. Either turn the custom select field into another asset field or use a system field for this to work as described here:

https://support.atlassian.com/assets/docs/configure-the-assets-object-field/

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.

...

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 system fields are case-sensitive and must be typed exactly as shown in the table below.

Work key	Label / Description	Multiple	Type	${key.id}	${key.label}
assignee	Assignee	false	ApplicationUser	userKey	Display Name
dueDate	Due Date	false	Date	dueDate	dueDate
fixVersions	Fix Versions	true	String/Custom Assets object	Id	Name
issueType	Work Type	false	String/Custom Assets object	Id	Name
components	Components	true	String/Custom Assets object	Id	Name
priority	Priority	false	String/Custom Assets object	Id	Name
project	Project	false	String/Custom Assets object	Id	Name
reporter	Reporter	false	ApplicationUser	userKey	Display Name
resolution	Resolution	false	String/Custom Assets object	Id	Name
summary	Summary	false	String	summary	summary