Set up the automation to fill in the Asset Object field with the reporter object

[Vadym Bezkorovainyi]

Hey There!

I'm trying to set the automation for my tickets. The simple one is to see who is reports the request via Portal, find this user in the Jira Assets and fill the custom field(assets objects type) with a object of this user from Assets. From the screenshot below i want automatically get the "Employee Full Name" filled with an object from Assets.



This is what i have done already so far and looks like automation works, but the field is not filled with an object :(



As you can see - it gets the data and can put the info in the Comments, but not fill the field. Any ideas why?

Thank you!

[Kim Euker · Accepted solution]

Since Employee Full Name is an asset field, all you need to do is to use the query you are using in the lookupObjects for your edit.  If you remove your text from the Employee Full Name field, you should see that it is looking for a query.  

Put this into your Employee Full Name on Edit.
ObjectType = "Employees" and "Atlassian Account ID" = {{issue.reporter}}

[Kim Euker]

Sure.  Here is an example:

When you have an asset field, it shows you that it is specifically looking for an AQL query, as shown in the example.

Replace that greyed text with your query:
ObjectType = "Employees" and "Atlassian Account ID" = {{issue.reporter}}

 Vadym Bezkorovainyi likes this

[Kim Euker]

@Vadym Bezkorovainyi   I reposted as my own answer to your question :-)

[Marc - Devoteam]

Hi @Vadym Bezkorovainyi 

Welcome to the community.

I see the field "Employee Full Name", is an asset field right or not?

If it's an assets field, what is the context of this field.

{{lookupObjects.name}} what will this give as result.

[Vadym Bezkorovainyi]

Hey @Marc - Devoteam 
Yes, it is asset field. Here is a context


{{lookupObjects.name}} - on the last screenshot there is a Comments for a tickets - it gives the name of attribute from Asset ObjectType

[Kim Euker]

Since Employee Full Name is an asset field, all you need to do is to use the query you are using in the lookupObjects for your edit.  If you remove your text from the Employee Full Name field, you should see that it is looking for a query.  

Put this into your Employee Full Name on Edit.
ObjectType = "Employees" and "Atlassian Account ID" = {{issue.reporter}}

[Vadym Bezkorovainyi]

Hey @Kim Euker
Thank you for the feedback!
If you can, please provide more info on what to do because I'm nooby with JSM :)

[Kim Euker]

Sure.  Here is an example:

When you have an asset field, it shows you that it is specifically looking for an AQL query, as shown in the example.

Replace that greyed text with your query:
ObjectType = "Employees" and "Atlassian Account ID" = {{issue.reporter}}

[Vadym Bezkorovainyi]

@Kim Euker, let me try

[Vadym Bezkorovainyi]

@Kim Eukeryou are my hero!
Thank you! IT WORKS NOW!

[Kim Euker]

@Vadym Bezkorovainyi   Please be sure to Accept my answer.  I'm glad it worked for you

[Tomislav Tobijas]

Hi @Vadym Bezkorovainyi ,

What's {{lookupObjects.get(0)}} returning? Is it object name/label or is it object key? If you could extract only the object key and store it in the field, I believe it will work. (we did something similar before)
Maybe try using {{lookupObjects.get(0).key}} and storing it in the field.

Can you also take a screenshot of this comment part/action and which smart values are you using there?

Cheers,
Tobi

[Vadym Bezkorovainyi]

Hey @Tomislav Tobijas 

I have tried  {{lookupObjects.get(0).key}} but still the same - not filled field there :(

Also adding the Audit Logs