(Insight) add related columns

[Jon Hill]

Is there any way to write an IQL query and then have the output include data from the object type being queried as well as one (or more) of the attributes of related objects?

I know I can query based on related objects using dot notation or inR().  For example:

"Service"."Location" IN ("NY","London") 

Is there any way for my query to return Service.Location (or other fields like Service.Status or Service.Owner)?

[Björn Gullander · Accepted solution]

No unfortunately you can only return attributes from the object type you are querying. 

Maybe there is a way to turn the query around to get the Service objects as a result instead?

If you were on DC there is a possibility to show referenced attributes in the Catalogue report and even better from the Confluence Insight Macro.