Finding complete path of a document

Bob_Trieger_(fidinv01user6_-_(deleted))

I wrote a query to sort documents by date last accessed. Using the DATAID, how do I list the complete path to the document?I.e., doc BOB.XLS has DATAID = 119923How do I list that BOB.XLS is actually Enterprise/somefolder/anotherfolder/folderx/BOB.XLSThanks!!

John W. Simon, Jr.

Bob,I've done this for an Oracle system, don't know if this code will work on a SqlServer system or not (but I would guess not). I created the PL/SQL below. The first query (called cur_project) is the query where you find the object(s) you want to report the path of.Good Luck.------------------------------------------------------------------------- declare lv_dataid number(10); lv_version number(10); lv_parentid number(10); cursor cur_project is select dataid from dtree where parentid = 31749; cursor cur_path_back_to_top is select name from dtree start with dataid = lv_dataid connect by prior parentid = dataid; lv_name varchar2(255); lv_path varchar2(2000);begin open cur_project; loop fetch cur_project into lv_dataid; exit when cur_project%NOTFOUND; lv_path := ''; open cur_path_back_to_top; loop fetch cur_path_back_to_top into lv_name; exit when cur_path_back_to_top%NOTFOUND; lv_path := lv_name || ':' || lv_path; end loop; dbms_output.put_line('path is ==> ' || lv_path ); if cur_path_back_to_top%ISOPEN then close cur_path_back_to_top; end if; end loop; if cur_project%ISOPEN then close cur_project; end if;end;