Jira Automation: Lookup Objects Error Message

Question

I have created an automation that runs when an issue is transitioned from one phase to another. When the automation is triggered an attribute within an asset object is updated.

However, for some reason the lookup keeps causing errors. The object lookup logic is as follows:

and has been causing the following error:

However, both the objectType and the Name (seen below) within the query logic seem correct to me. Am I missing something here?

Frederic Wolf · Answer

Where I'm seeing problems is with a separate automation that then updates vendor's attribute when the issue is transitioned to "Done".

--> You can not update a object from an issue triggered automation.

Haig Aboyan · Answer

The project for which this automation rules lives within is to manage 3rd party vendors within our org. Through a separate automation users can submit a request form which creates an issue and a vendor(the object).

Where I'm seeing problems is with a separate automation that then updates vendor's attribute when the issue is transitioned to "Done".

You can see below the vendor name is populated within the object.

Frederic Wolf · Answer

Hi @Haig Aboyan , i tried some AQL in my own asset structure and i could reproduce your error. Error Text: AQL "objecttype = manufacturer AND name = acer computer GmbH" has invalid syntax at position 42 with error message "mismatched input 'c' expecting {, ' '}" Nearly the same error. Just to clarify: I have done the search directly in Assets and not in a object lookup within an automation. But the result looks the same. I then changed the AQL and i added the quotes. Andd voila, no error. As you can see there is only 1 Result left. If we look into the error message again: AQL "objecttype = manufacturer AND name = acer computer GmbH" has invalid syntax at position 42 with error message "mismatched input 'c' expecting {, ' '}" And yours: which says "mismatched input 'V' We can assume that the starting letter of the second word is at the error position. Perhaps you can test it Again and change your AQL to: objectType = "Vendor" AND Name = "{{issue.Vendor Name}}" --- I have an additonal question. Perhaps you can explain the structure of your requeest type a little bit more. I assume you have a TEXT Field where the user can type the Vendor. Why don't you create an Asset Object Field, where you can link the asset directly?