EQL/SQL Query help

Question

Can someone help me with the EQL/SQL syntax that I would use to list out specific information about document files, specifically the folder (file path) they are in on the file server and the file name on the file server. I can't seem to find the exact table/field this is contained in in the eB version 15.6.1 schema.

Gintautas · Accepted Answer

Hello James, 
 
Script below will retrieve main information on Document and File (original name, path on server, file name on server) 
 
select d.prefix + ' ' + d.middle AS 'Document Number', d.revision 'Revision',d.title 'Title', 
ds.orig_file_name 'Original File Name',md.root_access +'\' + mr.path+'\'+mor.location AS 'File Location', mor.object_id 'File' 
from documents d, doc_source ds, m3_object_repository mor, m3_repositories mr, m3_device md 
where ds.document_id = d.document_id 
and mor.object_id = ds.m3_object_id 
and mor.repository_id = mr.repository_id 
and mr.m2_id = md.m2_id 
 
Cheers 
Gintautas

Carma De Villiers · Answer

Hi James, please send the detail on what you need to retrieve.

Swapnil Tapadia · Answer

Hello James, 
 
Here is the eQL, I hope it will meet you requirement: 
 
START WITH Document 
SELECT Code, Files.Copies.DocumentCopy.Code, Files.Name, Files.Path 
WHERE Files.Name <> ' ' 
 
Please let us know if you need anything more. 
 
Regards 
Swapnil Tapadia