How Consulting All names Documents

[Roldanhollow]

Well i have a problem with how a obtain all names documents in the Content Server...
And another problem is obtain all documents favorities in the content server...
Any one helpme?

Thx 4 advance.

 

[appnair]

using what ? a sql tool a development tool? all of this is possible with API's or queries.
have you gotten yourself a copy of the OT schema?it is free to a customer who signs an NDA
Then you need to look at some commonly available queries in the KB or so.

this query will list all the documents in livelink

select name,dataid,parentid from dtree where subtype=144

similarly favorites are user specific so it is stored in other tables which i do not know but if I was told
of this I would basically be at the database and see where the info can be mined.

so get yourself a SQL tool with which you can study the database



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

 

[Roldanhollow]

Thx appnair!
Another question...
Do you know how can build this query using Lapi?
Do you have any example?

Thx 4 advance!

 

[appnair]

First you create a Live Report object then follow an example of how lapi can call the Live Report
LAPI has been deprecated you should use webservices or the REST api

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

 

[Roldanhollow]

thx appnair for answer me...
do you can help me with any page or any example that mention about this?

Thx 4 advance friend!!