how to get file path based on the dataid

[mohanbond]

Hi Gurus,

I got some list of data ids for the documents in Livelink. Now I need to download the document, also I need to get the entire folder structure(upto root) information to save this metadata into sharepoint.

For downloading the document I'm using Sardine, but the sardine.list not giving the full path information.

Is there utility or sql procedure to get the filepath bases on dataid in Livelink?

Thanks for help.

--
Mohan

 

[appnair]

to get the path depending on the database you can wrte a function or stored procs. As I mentioned in your other post these reusable functions are in the KB
If you have a dataid and if you have livelink serach working one of the returned attributes in a search is the "location" which usually is the breadcrumb trail of the object.You can also do the pathing truly by wsapi which goes like ask for parentid until you reach the top ,they tend to be inefficient.DB queries will be much more efficient

http://www.tek-tips.com/faqs.cfm?fid=3552

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[mohanbond]

Thank you appnair. I got the query, but not 100% accurate, it gives path in reverse order, but this is ok. I'm using Java code, to call and change this.

select connect_by_root(d.dataid) dataid, SYS_CONNECT_BY_PATH(d.name, '/') path from dtree d where connect_by_isleaf =1 start with d.dataid= 1691706 connect by prior d.parentid=d.dataid;