Lookup Asset, then get a referenced objektType Name

[Tarik Userli]

Hello,

i have a objektType called "Software", there is all our Software listed with attributes like

• Name
• Vendor
• Software lead
• Team

The "Team" attribute is another objektType with all of our Teams ("zuständies Team") with attributes like

• Name
• Lead
• Members
• etc

Now my issue is, if i want to get the Team Name via lookup inside the Automation i just get back the key but not the name. 

my steps are:

Lookup Asset (Insight) object with ScriptRunner

-> {{issue.customfield_13821.key}} - customfield with the referenced Software

for troubleshooting: Comment on issue 

• Objekt Key: {{issue.customfield_13821.key}} - Works
• Objektname: {{lookupAsset.objectType.Name}}
• Team: {{lookupAsset.attributes.zuständiges Team.Name}}
• Team: {{lookupAsset.attributes.zuständiges Team}}
• Fachbereich: {{lookupAsset.attributes.Fachbereich}}

My commments show me this:

Objekt Key: ITA-80844

Objektname: Software
Team:
Team: 56885
Fachbereich: KAS-KHBA-KLK: KIS

{Name=CGM Medico, Status=30, Fachbereich=KAS-KHBA-KLK: KIS, Hersteller=80945, Kategorie=Anwendung, zuständiges Team=56885}

So i just get the key but not the name from my Object.

And i cant get the key in any ways.

[Tarik Userli · Accepted solution]

Got it by myself.

For all who want to do the same:

Automation:

• Lookup Asset (Insight) object with ScriptRunner
  • {{issue.customfield_XXXXX.key}}

• Create variable

  • Variable name - NameYourVariable
  • Smart value - {{lookupAsset.attributes.AttributeName}}

• Lookup Asset (Insight) object with ScriptRunner

  • ObjectKey-{{NameYourVariable}}
• for troubleshooting
  • Comment Issue - {{lookupAsset.attributes.Name}}
  • log info - {{lookupAsset.attributes.Name}}

[Raphael Lopes]

Hello!!

@Tarik Userli 

Try change from ".key" to ".label", maybe this work.

Regards.

[Tarik Userli]

Hey Raphael,

i allready gave this a chance but did not work :(

[Marc - Devoteam]

Hi @Tarik Userli 

Whenever you ask for help with an Automation Rule it will help us to help you if you provide:

1. what type of project is this (e.g., company-managed, team-managed, etc.), 

2. images that show your complete rule.

3. images showing the details of any relevant actions/conditions/branches.

4. images showing the Audit Log details for the rule execution.

5. Explain where the issue is.

These questions are not for not willing to help, but to have community members understand on how automation works.

[Marc - Devoteam]

Hi @Tarik Userli 

Can you provide the details I asked and the details of an object from assets?

[Tarik Userli]

Project is Company managed JSM

How i already wrote in my main post: issue is that the smar value does not reply the team name just the team key

[Marc - Devoteam]

Hi @Tarik Userli 

So in your lookup object action this value is not found, so yes then it will not be shown in the comment as well.

I see you are on DC and use Scriptrunner ,as the function in the automation is not ootb.

I think this should work: {{lookupAsset.zuständiges Team.Name}}

Best practice is to add a log action, after the lookup. Log the values you would want to use, this will give you insight on what you are missing already before actioning.