I am trying to loacte all categories in the system , listing its attributes ( I got this working with ?func=attributes.dump) However, I am wondering if "Data Type" and "Length of attributes" is stored in DB and can be queried ?
That RH in livelink 9.7.1 executes a first query
select * from dtree where subtype=131 (that is all cats in your system)
Then it proceeds to locate all the versions of a category which is in the filesystem like a document.It has cryptic looking data structurs parsable by livelink's prog langauge called oscript.So it is not obtianable via a sql tool.
There is another table called catregionmap which may have similar info.
Recently a user posted a livelink URL with a specific action written for getting the category info in CS10.I beleive one could
probably say it is kind of a RESTful kind of API call perhaps a SQL tool allows you to consume XML?
What is your livelink version if you say that I can take a look as well
Thanks for the reply !
We are on Livelink 9.7.1
Try this Oracle script to break the Categories and Attributes down...
The Type column is the datatype of the Attribute, see https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objaction=overview&objid=13682418 for what the numbers in the column refer to on page 29. To include the other elements of the Category / Attribute you want it should be a simple WebLingo customisation to the dump.html file.
