Content type IDs mapping to type Names

Hello,

My problem is simple but it's proving hard to solve. I just need to map a TYPE ID to it's TYPE NAME. Does anyone know how can I do this? I mean, to get a list of all the available types in Content Server through CWS?

Here is what I already know:

Going through the source code of the (soon to be deprecated) LAPI I found some type names hardcoded in the LAPI_DOCUMENTS.class.
I can get an item type name - we need a complete (type name, type id) map
I can get an item type ID by looking at the database - again we need a complete list of these types and not jus the TYPE ID
I couldn't found any reference to this in the CS database
I can get this info through Admin > Content Server Administration > System Report - I would rather do this through CWS
DocumentManagement getNodeTypes method only gives the type names - again we need some way to map these names to their IDs

Best Regards

Find more posts tagged with

Comments

Kevin_Mark

Hi Natercio, have you read this thread?

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=57834547&objAction=viewincontainer&ShowReplyEntry=57809876#forum_topic_57809876

In the last post, Kyle suggests that a livereport might do the trick

eLink User

The registry on NodeTypes is derived internally by Oscript which is what system report gives you.For purposes like this we put lookup tables for convenience by looking at available modules in an install.Now can you do that in pure CWS fashion you bet you just have to create a client API call for that,if you don't consider getting that info from a live report.I recall a posting by Chris Webster asking why do you need to know the type(144) of a Document ? Other than academic purposes is there a value?If you find one in your lapi code I would just do select * from dtree where subtype=<what I found in lapi code > and then look at it thru the GUI to know what it is...

In any case if I m a customer who installs the Contract module from OT I will get node subtypes that are relevant like Binder,Contract etc.If I put in the Transmittals system I will get nodes like .Greg's website has a kind of an all encompassing registry,OT maintains a vendor oscript registry,we create custom subtypes in our org that wouldn't be public.

Here's an excerpt of our table that we give to client programmers they use it with LiveReports.We do the same for category_definitions as well which helps them.

CREATE TABLE ZCOP_LL_SUBTYPELOOKUP ( SUBTYPE_NAME VARCHAR2(255 CHAR) NOT NULL, SUBTYPE_ID VARCHAR2(255 CHAR) NOT NULL, CONTAINER VARCHAR2(15) );

insert into ZCOP_LL_SUBTYPELOOKUP (SUBTYPE_NAME, SUBTYPE_ID, CONTAINER) values ('Folder', '0', 'Container');

insert into ZCOP_LL_SUBTYPELOOKUP (SUBTYPE_NAME, SUBTYPE_ID, CONTAINER) values ('Shortcut', '1', 'Non Container');

insert into ZCOP_LL_SUBTYPELOOKUP (SUBTYPE_NAME, SUBTYPE_ID, CONTAINER) values ('Generation', '2', 'Non Container');

insert into ZCOP_LL_SUBTYPELOOKUP (SUBTYPE_NAME, SUBTYPE_ID, CONTAINER) values ('Workflow Map', '128', 'Non Container');

insert into ZCOP_LL_SUBTYPELOOKUP (SUBTYPE_NAME, SUBTYPE_ID, CONTAINER) values ('Topic', '130', 'Container');

.....appu appnair appunair

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Thu, Jan 21, 2016 at 1:16 PM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

Content type IDs mapping to type Names Posted byMoniz, NatércioOn 01/21/2016 02:15 PM

Hello,My problem is simple but it's proving hard to solve. I just need to map a TYPE ID to it's TYPE NAME. Does anyone know how can I do this? I mean, to get a list of all the available types in Content Server through CWS?

Here is what I already know:
Going through the source code of the (soon to be deprecated) LAPI I found some type names hardcoded in the LAPI_DOCUMENTS.class.

I can get an item type name - we need a complete (type name, type id) map

I can get an item type ID by looking at the database - again we need a complete list of these types and not jus the TYPE ID

I couldn't found any reference to this in the CS database

I can get this info through Admin > Content Server Administration > System Report - I would rather do this through CWS

DocumentManagement getNodeTypes method only gives the type names - again we need some way to map these names to their IDs
Best Regards
[To post a comment, use the normal reply function]
Forum: Content Web Services Forum
Content Server: Knowledge Center

prototyp3

Thank you both for your help!