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.
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.
Hi Patrick, has this issue been resolved?
Answer Verified By: Carma De Villiers