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é