EQL Report on all documents containing no files

Hi Dean,

I have a eQL query which can will help you.

Query:

START WITH Document 

SELECT 
   Id,
   Code,
   Name,
   State,
   Files.Id 
WHERE 
   State = 'Draft'
   AND Files.Id IS NULL 

I have tested this on to eB 16.4  version. I don't know if it will work onto previous version or not.

Let me know if it works for you.

Regards,

Sayyad