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.
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