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}}")