AQL Condition Used on Issue Field

[LGU]

Hello there,

I hope someone can help me out with this very simple question. (Can't find the answer anywhere :( 

I have an Asset type customfield on an issue that contains an Employee object from our asset management and I'm working on automation and can't figure out what is the correct format for AQL Condition in the automation.

I just want something simple like "Display Name" = "Lukas" to work (if the object has attribute Display Name and it is equal to Lukas). But it doesn't. I tried different object attributes, I tried some object keywords, I tried NOT EMPTY keyword, and everything returns to me in the log :" If block, Assets field condition failed"

Thanks a lot for any input on this.

[Mikael Sandberg · Accepted solution]

If you want to search on the asset in a JQL you have to use the aqlFunction as part of your query. Here is an example:

MyCustomField in aqlFunction("Employee.\"Display Name\" like \"Lukas\"")

[LGU]

Thank you for the reply Mikael, I found out the problem when trying to formulate a reply to you. (had the wrong custom field selected in the AQL condition - yea embarrasing :D )

But the information about aqlFunction in JQL is quite useful too!