Stucture needed to allow for Dot notation AQL for Assets

Question

Hi!

My Assets stucture is as follows. Our Camera Assets can have three different locations. Either "Site", "Warehouse" or "Supplier". We therefor have an attribute field for the camares called "Location", this field connects the abstract objecttype "Location" who´s child object types are "Site", "Warehouse" and "Supplier".

There is however an issue with this. We want to allow users to use the dot annotation search function with AQL. For example, we would like to find all Cameras where the Site has a specific server installed.

We can only get this feature to work IF the Location attribute for the Camera is directly connected to the "Site"-object and not the parent object "Location".

Is there a way around this? We would like to keep only one field for the cameras where we state the actual location, but it can contain several object types such as "Site", "Warehouse" and "Supplier".

Thank you!

Sal_5bnbl8 · Answer

older topic but maybe for someone else. I got it working like this:

objectType = "object type name" AND object having outboundReferences(object having outboundReferences(AQL,referenceName)).

Assumptions of your scheme: Camera -> Site -> Server and the reference from site to server is called "installed servers". So in your example:

objectType = "Camera" AND object having outboundReferences(object having outboundReferences(Name = "Servername","installed servers")).

Johannes Nyberg · Answer

What this means is that our structure won´t work? You can´t connect the object to a parent object and enable dot notation searches in the child objects?

Joseph Chung Yin · Answer

@Johannes Nyberg -

Based on my knowledge, you would need to establish association between your "Camera" object with your other objects (i.e. Sites).  In your "Camera" object configuration should contain reference attributes (pulled from your other objects) in each Camera object record.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.