Stucture needed to allow for Dot notation AQL for Assets

Johannes Nyberg
Contributor
December 14, 2023

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!

Untitled.png

 

1 answer

0 votes
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 14, 2023

@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.

Johannes Nyberg
Contributor
December 15, 2023

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?

Sal
Contributor
May 27, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events