Automation of edit field from asset value

[steven.allcock]

I am trying to update an approval group by automation to edit the issue and update the value with a value in an asset but when i run the automation its pulling the approval groups for all objects in the object type.

Im sure its something simple in lookup query but I cant figure it out

Anyone got any ideas what im doing wrong here?

[Mikael Sandberg · Accepted solution]

It is because your lookup object AQL is too broad. You are pulling all objects in the object type, not just a single object. You would need to include an unique identifier for the object you want, which I guess in this case is the TIA Profile ID. So if you change the AQL to something like this it should work:

objectType = "TIA Profiles" AND key = {{issue.TIA Profile ID}}

[steven.allcock]

Thank you, that's it.

I appreciate your help on that one, still new to assets :-)