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 ID | objectType | displayname | Manager |
---|---|---|---|
ORG-1 | LTW_Employee | Tom | Amy (ORG-2) |
ORG-2 | LTW_Employee | Amy | Bob |
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!
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}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.