User needs to find documents with hidden file(s)


 

Product

  
 Applies To 
  
 Product(s):eB Information Manager
 Version(s):15.x.x
 Environment: N/A
 Area: Report
 Subarea: Files
 Original Author:Dennis Chan, Bentley Product Advantage Team

Problem Description:

User needs to find documents with hidden file(s).

Cause:

N/A

Solution:

The following eQL will find documents with hidden file(s).

START WITH DocumentCopy
SELECT
   Id,
   Code,
   Document.Code,
   Document.Name,
   Files.File.Name,
   Files.Sequence,
   Files.SequenceName
WHERE
   Files.Sequence < 1

Workaround:

N/A