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

[Trudy Claspill]

Hello @Michael Frade 

Getting the ones that have nothing specified for category is pretty straight forward:

Category is empty

The rest of it is more difficult and I have not yet figured out a solution.

This will give you all the objects that have an exact match for Category containing both AA and BB, which is the opposite of what you want.

"Category" = "AA" AND "Category" = "BB"

While the following excludes the ones that exactly match, it also excludes the ones that have "AA" or "BB" alone or in combination with anything else, and that doesn't match your requirement

"Category" != AA AND "Category" != BB

How many total objects are in the object type that you want to examine? You could do an export of all objects of that type, and an export of all objects that exactly match, and then cross reference the two lists (in another app) to exclude from the full list the ones from your exactly-match list.