How can I get referenced objects in Assets, using Automation?

[Thomas Pedersen Ljungstrom]

Let's say I have these object types connected like this:

Region - Country - City

When a user creates a work item and in here selects a Region, I want to use Automation for searching Assets and find all countries and cities connected to this region and add the result in a comment.

I know how I can find first level results (countries).

But next level, cities, I'm struggling to get right. And if I had Attractions for each City as well, how would I find and list those?

[Rudy Holtkamp]

Hi @Thomas Pedersen Ljungstrom ,

Like @Marc -Devoteam- it does help a lot to post more data.

Having said that, I can make an assumption that you have referenced the objecttypes like:

Region <- Country <- City <- Attractions

Meaning the attribute of an attraction is City, the attribute of a city is country, etc.

Suppose you have set an Asset custom field called Region, then you can use this lookup AQL to get your data for attractions:

objecttype = Attractions and objects having outR(objecttype = City and objects having outR(objecttype = Country and objects having outR(objecttype = Region and Name = "{{issue.Region.label}}")))

For Cities, you peel off the outer layer:

objecttype = City and objects having outR(objecttype = Country and objects having outR(objecttype = Region and Name = "{{issue.Region.label}}"))

Same for Countries:

objecttype = Country and objects having outR(objecttype = Region and Name = "{{issue.Region.label}}")

[Marc -Devoteam-]

Hi @Thomas Pedersen Ljungstrom 

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.

Also share details of your structure in aseets