DQL to get the folder_path from r_object_id
Select s.r_object_id, fr.r_folder_path + s.object_name
From dm_sysobject s,dm_sysobject_r sr,dm_sysobject_r sr3, dm_folder_r fr
Where s.i_is_deleted = 0
AND sr3.r_object_id = s.r_object_id
AND sr3.i_position = -1
AND sr.r_object_id = s.r_object_id
AND fr.r_object_id = sr.i_folder_id
AND fr.i_position = -1
AND s.r_object_id = '[OBJECT_ID]'


0 Comments:
Post a Comment
<< Home