LiveLink: List all objects in a folder 1

[starbase51]

Hi

Does anyone have any examples of code (vb in preference) that will list all children of a parent folder, I need to download all objects and store the contents in a db.

Thanks
Stu

 

[appnair]

SELECT DTREE.SUBTYPE, DTREE.DATAID, DTREE.NAME FROM LIVELINK_DTREE
WHERE (((DTREE.SUBTYPE)=0));
this will give you all the number of folders
A second iteration of the result set with

select parentid,name,dataid,childcount from dtree where parentid=< dataid row from first result set> should give you what you are looking for.
However this is only metadata.How are you going to gey to actual data.that is a blob or external storage as the case maybe.

You should be able to run this query thru livereport or,VB or java

Run a describe on dtree and dversdata and you wil understand most of the stuff.

 

[starbase51]

Hi

I am using the livelink api, am I able to perform direct sql statements via this?

(sorry about my lack of knowledge, up until a week ago I hadn't used livelink before)

Thanks

 

[appnair]

SELECT LIVELINK_DTREE.parentid, LIVELINK_DTREE.DATAID, LIVELINK_DTREE.NAME, LIVELINK_DTREE.childcount
FROM LIVELINK_DTREE
WHERE (((LIVELINK_DTREE.parentid)=2328));

I had the wrong column in second query it should.In the above example 2328 is a folder in my enterprise

 

[appnair]

You do not need lapi .You should be able to use any ODBC/JDBC compliant driver to run your query.LAPI is useful if you want to say download a livelink document/upload,run workflows etc not from the web client.LAPI is the programmer's backdoor to livelink.The queries I sent you I constructed an ODBC oracle driver to my Livelink installation and ran it before I sent you.I guess you can write a VB app that will run the first query and pass the second parameter to it what you are looking for.you should be able to test the queries i sent you thru live report.if you have an email id i will send you the same query as a live report.in this case you don't need the database connection parameters.I personally prefer using java since I'm more at ease with it.have luck.look in the lAPI section in the open text Knowledge base.As your livelink admin if you can get one.

 

[starbase51]

I'll give it a try, thanks for your help.