Aql query for an exact match for an object reference attribute

Michael Frade

We have an Object type that is used as an attribute reference across multiple other object types, it provides categorization. The cardinality for those attributes is set to max. For the respective various object types there is a set number of objects we want togged to the individual objects.  I am trying to find a way to build a query that looks for objects that do not match what we expect to have listed for objects in that object type.

 

So if the category object type has objects A,B,C,D, F.

The Laptop Object type has an attribute for the category object type and we expect to have A, D and F  in every category attribute for Laptop. 

Looking to build a query that looks at the category attribute and returns any object that does not have A,D,F  exactly.

If category attribute has A and D that should get returned in the results 

If category attribute has nothing that should get returned in the results

If category attribute has A and F that should get returned in the results 

and so on

Hope that makes sense

Michael Frade

Used the below in the AQL query with the key in the brackets  with OR statements in between the individual  query to get what is required for that object type 

 

object NOT HAVING outboundReferences( )

 

also need to create a variable and use the Split(",") function to edit the object as edit deletes what exists in the attribute