I need to make a query that display the folder path of some documents. I´m sure that it´s something very basic for anybody that knows it, but I don´t know what I´m doing wrong...I´ve tryed this:
select doc.r_object_id ,fol.r_object_id, doc.object_name ,fol.r_folder_path
from dm_folder fol, dm_document doc
where any doc.i_folder_id=fol.r_object_id and doc.object_name like 'Doc%'
I think that the problem is in the attribute r_folder_path. How can I solve it??
Thanks
