Norbert Gál

EPDM Report all files

Discussion created by Norbert Gál on Jan 16, 2020
Latest reply on Jan 18, 2020 by Norbert Gál

Hi,

 

I would like to write a report file (.crp) what can list all of the file in the vault, but I stucked with path and users.

This simple report runs fine, but I can not figure out how can I add the folder name and the User name user who was checked in (or added to vault).

I tried to find information (google, Report Examples 1.crp) but I'm beginner in SQL.

 

@[ListAllDoc]
§Name [List all documents]
§Company [Econ]
§Description [This query lists all documents]
§Version [1.0]
§Arguments [ ]
§Sql
[
SELECT D.Filename as 'File Name'
FROM Documents D
WHERE D.Filename LIKE '%'
]

 

Thank you

Outcomes