Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help 4 newbie: how to get a list of all sub folders

Status
Not open for further replies.

tmorsi

Programmer
Sep 22, 2008
18
US
hey complete newbie on livelink,

i've got an objectID for a folder,

How can I obtain a list of all sub-folders within this folder ?

really what i would like is list of all the urls to these sub-folders...

any good docs/references for the api for newbies would help too ...

thanks
 


FolderA
FolderB
FolderC

ListObjects on dataid of FolderA will give the first list and will contain FolderB.You will have to Recurse FolderB again in ListObjects to get FolderC.LAPI does not have any node crawling routines.

ListObjects can take a parameter which equates itself to
"select * from dtree where subtype=0"


If all you were intereted was url's of the folders try xmlsearchapi which is doen thru the livelink search interface.


Good refrences

OT KB knowledge.opentext.com
Communities communities.opentext.com


Another way would be to write a LR that crawls the folder structure and call this livereport thru lapi.If your datbase is Oracle the standard connect by between dataid and parentid will recurse the folders for you

Trying to find childern folders of 12345 folderid in a livelink WITH ORACLE as the DB will not work in
SQLserver

select level,dataid,parentid from dtree where subtype=0
connect by prior dataid=parentid start with dataid=12345




Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
 
hey thanks for the insight,
if i get it to work i'll post the code
thanks

anyone have a link to the developers api doc ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top