nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using automation, how do I lookup an Asset attribute value use that to set a field on the issue?

Marcus Lopez

We use Jira Asset Management and have a [Unit] object with an Attribute that we have configured with the "Organization". When requestors submit a new ticket, the [Unit] Asset field is on the request intake. I want to use automation to have Jira lookup the Organization attribute in the Asset record for the Unit and then set the Organization on the Issue to that value.

I see in the automation that I can set a value on the Asset but can't seem to find where I would lookup from the Asset and subsequently set a field value on the Issue itself. Thoughts? s

Accepted answers

Frederic Chartrand

Hi @Marcus Lopez

First, you need to create another custom field for where you want to store the info about Organization if it's not already done.

After that, you can use the Lookup objects action in Automation and the request would be : objectType = Unit and Key = {{issue.unit}} (unit being you're customfield here)

Finally, you add another action Edit issue, you choose your field and you add the info by using the smart value {{lookupObjects.Organization}}

If the Organization attribute refers to another Assets object, I'd create an Assets custom field to store the Organization. If not you can create a simple text field.

Hope this helps.

All comments

Mikael Sandberg

It should be pretty straight forward, all you have do is add the lookup object component and set it up to search your object schema and then use the selected unit to find the object. Then you can use {{lookupObjects.Organization}} to set Organization.

Something like this:

Screenshot 2023-05-19 at 11.10.19 AM.png

In this case I am looking up departments based on what was selected on the form and then get attributes from that object to set the approvers.

Frederic Chartrand

Hi @Marcus Lopez

First, you need to create another custom field for where you want to store the info about Organization if it's not already done.

After that, you can use the Lookup objects action in Automation and the request would be : objectType = Unit and Key = {{issue.unit}} (unit being you're customfield here)

Finally, you add another action Edit issue, you choose your field and you add the info by using the smart value {{lookupObjects.Organization}}

If the Organization attribute refers to another Assets object, I'd create an Assets custom field to store the Organization. If not you can create a simple text field.

Hope this helps.

Marcus Lopez

Thank you! I think I'm close. I put a 'log' step in there to verify it's pulling the Attribute from the Object, and it is. But then I get a parsing error. First image is from the automation log - shows "Albuquerque" which is the Unit Name ... and this is what is output to the log: {{lookupObjects.Organization (Jira)}}

Then I try to edit the issue with the second image below, which is giving the parsing error. Not sure what I'm doing wrong.

Mikael Sandberg

Your JSON that you are using is missing "" around the smart value, try this:

{

"fields": {

"organizations": {{lookupObjects.Organization (Jira)}}"

}

Marcus Lopez

Okay, getting closer. It doesn't like the text value that's in that attribute. I wants a numeric. Do I have to change the data type for the field or is there some magic I can do?

Anne Warmer

I'd like to use this in Jira Business Project. Why is the functionality only available in JSM?

Do you know if there are any plans to make it available in Jira (fka Software or Workmanagement) ?

Mikael Sandberg

Hi @Anne Warmer,

This should be its own question, but the main reason is that Assets is a functionality that is par of JSM. You are still able to use an assets field in Jira, but in order to have access to it you need to have JSM access.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management