EQL report - Documents/Virtual item

Good afternoon,

I need to create a report to establish which documents in our database are not linked to a Virtual item/structure/group?

Below are one of the many instances I've tried without success.

START WITH Document
SELECT 
   Document
   Name,
   Middle,
   Description,
   Id
WHERE 
    VirtualItemGroups.RelationshipType.Value is NULL
 

Can you please assist me with possibly the correct WHERE statement?

Kind Regards,

Jeanné

Parents Reply Children