How to use Asset custom field in automation

[Steve Mélon]

Hello there, 

We're using Asset w/ Jira Service Management and I would like to know how to do the following : 

When an issue is created, check the value of an asset type custom field and then operate some action. 

The user is invited to pick a center to declare an incident and depending on the zone where the center is located , the request will be edited in certain ways. 

Center is an object that has a reference on another object call Zone.  

As you can see in the image: I would like to do something such as : {{customfield}}.Zone.name = "Wallonie Est" 

Is this feasible? 

Many thanks :) 

[Sam Huawey · Accepted solution]

The only working code I managed to create for Assets custom field is the following:

{{issue.MyAssetField.asJsonStringArray.substringBeforeLast(" (").substring(2)}}



asJsonStringArray converts internal Java object into string like this:

["value (KEY-22)"]

Other 2 functions convert JSON to actual value.

Perhaps Atlassian should think about exposing Asset object fields as properties in Smart Values, but as for now they did not do it.

[Matt Donnelly]

This was exactly what I needed, thank you!

[Julius Zatroch]

In Server/DataCenter Automation works: 

{{issue.MyAssetField.summary}}  =  value

{{issue.MyAssetField.key}}  =  KEY-22

{{issue.MyAssetField}}  =  value (KEY-22)"

[Xavier Tang · Accepted solution]

Hi,

I looked for a solution to update a custom field using an asset objet contained in an asset type field of the same issue within a Data Center Instance. I found this discussion as well as others, but I failled to produce a relevent solution. Finally, I met this page: https://confluence.atlassian.com/servicemanagementserver0505/post-functions-1206783457.html. It's easy to use post functions of Jira workflow to solve my concern.

Cheers.

Xavier

[Steve Mélon]

Hello  @Paul Wiggers

Thanks for your input. Unfortunately, I cannot find the LookupObject action in the list of possibles actions. 

But in my case, maybe i can already access the field? It's a custom field of type asset that is already select by the users and what I would like to do is : 

When issue created 

IF {{customFieldId_13901.Zone.Label}} is equal to "A value" 

Then

Edit issue 

[Paul Wiggers]

Hello @Steve Mélon 

Thank you for your question and yes, this is certainly possible!

In your automation, you first need to Lookup the Asset object that you would like to use.

Use the Lookup Object action, specify your schema and set the query. For instance, here I am getting the customer object based on the reporter from our ITSM schema:

When you have fetched your object. You can use the details further down in the automation by using the smart value {{llookupObjects}}. For instance, here I am filling the label field with a customers country of residence:



Is this something you can work with or do you need some additional assistance?

Kind regards,

Paul

[Steve Mélon]

Hello  @Paul Wiggers

Thanks for your input. Unfortunately, I cannot find the LookupObject action in the list of possibles actions. 

But in my case, maybe i can already access the field? It's a custom field of type asset that is already select by the users and what I would like to do is : 

When issue created 

IF {{customFieldId_13901.Zone.Label}} is equal to "A value" 

Then

Edit issue 

[Dave Furlani]

Hi @Steve Mélon, this page might help - https://confluence.atlassian.com/jirakb/how-to-copy-from-to-asset-field-value-to-from-jira-text-custom-field-using-automation-for-assets-1236938142.html