Error when using the Filter issue scope (AQL) in a customfield.

[Ste404]

Hi there,

I am making an Assets custom field that is going to just list objects filtered by a custom field on a form.

I have this line in the Filter issue scope (AQL)

"Owner" = ${customfield_10143}

Owner is a USER attribute type in Assets

customfield_10143 is a single user select field.

I am getting this error all the time

"The AQL query contains one or more placeholder custom field IDs that are invalid or not Assets object fields."

When I put the } in place.  There is a green tick right up to that point?

what am I doing wrong with this one?

[Ste404 · Accepted solution]

Decided to wipe that AQL completely and just populate the field from an automation.

Nothing to see here, move along :)

[Vittoria Oliva]

Hi @Ste404 

please try it:

"Owner" = $customfield_10143.label 

It seems work fine.

BR,

Vittoria

[Axel SAMYN]

The syntax may be correct but I don't think that the AQL will work. I just tried to replace ${customfield_xxxxx} with $customfield_xxxxx and that broke my asset field.