Automating lookup of object Inbound References

Ari Raatikainen

Hi,
Using automation, how to lookup from a object its all inbound references? See picture where object is having 3 references to "Application" objects and which are stored in different schema. The outbound attribute in referenced Application object is "Business application". 

 

 

How the output could be used e.g. in mail body?

Kevin Patterson_u4sm4w

Hi @Ari Raatikainen 

You should be able to do this with an inbound reference in your lookup Objects AQL query.

In your lookup Objections Action set your Schema to the Schema that contains your application objects and for your query start with:

object HAVING inR(Key in ({{issue.customfield_XXXXX}}))

Be sure an replace customfield_XXXXX with your custom field ID that contains the object that has the relationships you are trying to retrieve.

Once you have validated that this is returning your objects (I use a log action to do this) you can build on this AQL and adjust it to return only the results based on further filtering ie: only certain object types and/or relationship/link names.

Here is a link to Atlassian documentation that I use when building my AQL queries https://support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/

Let us know how you it works out.