eB REPORT - Search for all related documents of a specific class to a specific class of a physical item

I would like to have a report who returns a list of all physical items of a specific class/name with their related document of a specific class.

Can somebody help me with syntax please.

Parents
  • Hi Patrick,

    Please try below eQL to get the required result:

    START WITH PhysicalItem 
    SELECT 
       Id,
       Class.Name,
       Code,
       Documents.Document.Class.Id,
       Documents.Document.Code,
       Documents.Document.Name,
       Status 
    WHERE 
       Class.Code LIKE '%ABC%'
       OR
       Documents.Document.Class.Path LIKE '%XYZ%'

     

    Let me know if you find any issue on the same.

    Regards,
    Manav B.



Reply Children
No Data