AQL to fetch all objects of a certain type from a schema that are missing a child

Question

I have to define a custom field of type Assets Object, that will fetch all objects in a schema that have no children.

The schema defined object type Alpha that have children objects of type Beta and Gamma.

Sometimes the Gamma child was detached from the relationship.

I want the custom field of type Asset Objects to fetch all the Alpha type objects that are missing the Gamma child. I need to write thet AQL for that. Is it possible?

Petru Simion [Simitech Ltd.] · Accepted Answer

I found the solution myself it is using

object NOT having inR(objectType = "[OBJECT TYPE]")