How to Configure an Assets Custom Field to Display a Manager Based on Employee Selection

LogicalisTW
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 3, 2025

 

I currently have one custom field where I select an employee by displayname, such as "Tom," and I need another new custom field to display Tom's manager, "Amy." Specifically, the new field should be able to select "Amy" with the object ID ORG-2.


Here is my Assets data:

 

LTW_Employee


Object IDobjectTypedisplaynameManager
ORG-1LTW_EmployeeTomAmy (ORG-2)
ORG-2LTW_EmployeeAmyBob

 

 

The first field is an "Assets objects" custom field that allows me to choose an employee (e.g., ORG-1 for "Tom").

The Manager attribute is a linked object, pointing to another LTW_Employee (e.g., ORG-1 links to ORG-2 for "Amy").

The second field should dynamically show the manager (e.g., "Amy" from ORG-2) based on the first field’s selection.

I tried configuring the second field with the following AQL in the Filter Issue Scope:

key = ${customfield_12345.Manager}

 

(where customfield_12345 is the ID of the first field), but I got an error: "The AQL query contains one or more placeholder values that are invalid or incorrectly formatted."


How can I achieve this? Is there a correct AQL syntax to reference the Manager attribute of the first field’s selected object? Or do I need to use Automation for Jira to make this work? Any help or examples would be appreciated!

1 answer

0 votes
Calvin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 3, 2025

Hi, my guess is in the second custom field is also an asset one? As such you want to return the "object" not "key"?

Maybe try:

object = ${customerfield_1234.Manager}

LogicalisTW
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 3, 2025

截圖 2025-03-03 下午5.43.27.png

Calvin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 3, 2025

Apologies, turns out I'm reading this the wrong way, so removing the comment. The only way I know how to do via the filter scope itself is by using the inbound or outbound reference.

eg:

object HAVING inR(objectId IN ($custom_field_xxxxx${0}}), refType IN ("Reports to"))

Changing Report to, to manager to or however reference type you have setup for that object.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events