DQL query to list files and file folder path
Created: 23 May 2011 Modified:Originally published on chrislynch.info website.
SELECT fr.r_folder_path, s.object_name, s.r_modifier, s.r_modify_date, sr.authors
FROM dm_sysobject s, dm_sysobject_r sr, dm_folder_r fr
WHERE FOLDER('/WCM/downloads/usacc', descend)
AND sr.i_folder_id = fr.r_object_id
AND s.r_object_id = sr.r_object_id
AND sr.i_position = -1
AND fr.i_position = -1
AND s.i_is_deleted = 0
order by fr.r_folder_path