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

[Petru Simion _Simitech Ltd__]

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 solution]

I found the solution myself it is using 

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

[Pablo Vergara]

Hi @Petru Simion _Simitech Ltd__ 

Refer to the Employees (Alpha), Non-contractor (Beta), and Contractor (Gamma) attached schema and example.

As you can see, you can filter those Alpha objects having no Gamma child objects linked up and present them in a custom asset field using AQL within the field config.

I hope this example helps you!

Just in case you're wondering what the link configuration is: