Need to query the documents in the Project Collaboration

Products

• Clarity PPM On Premise

Issue/Introduction

Need to get a query to get the list of the documents and the mapped projects which are using the collaboration feature to store the documents. Need a list of documents and the projects that hold them. 

Environment

Release:

Component:

Resolution

Here is an example of query you can use for your needs, feel free to run it and modify accordingly:

select fo.assoc_obj_id, i.name as Project_Name, fi.name as File_Name, fo.path_name, fo.name as Folder_Name

from clb_dms_files fi, clb_dms_folders fo, inv_investments i

where fi.parent_folder_id =fo.id

and fo.assoc_obj_id =i.id