How to retrieve nested categories from Category Volume/ Content Server Categories

Maqsood Khan

Hi All,

I'm new to OT CS and trying to retrieve following categories using CWS (Java).

Category Structure in CS10.5:

Category Volume

|-- HR (Type: Category Folder)

|-- HR Sub Category1 (Type: Category)

|-- HR Sub Category2 (Type: Category)

|-- Retail (Type: Category)

Question: How can I retrieve nested categories of type "category" from CS by passing root catogry name/ id?

I tried with below method call but it doesn't provide me with nested categories:

CatWS = docManClient.getRootNode("CategoriesWS");
CatFolder = docManClient.getNodeByName(CatWS.getID(), "HR Categories");

Appreciate any help or pointer.

Maqsood Khan

Find more posts tagged with

Comments

eLink User

Each categoryhas a subtype=131 and if it is a category folder it has a subtype 132

select* from dtree wheresubtype=133 //Gives you category Volume this is your docManClient.getRootNode("CategoriesWS");

So in a oracle connect by construct one can do this level is a pseudo column in oracle. Noteif you are SQLserver( connect by is aCTE in SQLserver) or Oracle and yourlivelink is very new the

Table dtreeancestorscontain the parent /child relation of the node. It will run very fast as well.Check the LR forum to find dtreeancestors queries aplenty.

selectname,dataid,subtype,levelfrom dtree

connectby priordataid=parentid

startwith dataid=(selectdataid from dtreewhere subtype=133);

132 also a 131need not be in a category folder or volume as well.

Why am I sayingthis in a WR forum? If you purely want to keep it in WSAPI code you will hitthe volume and for each category folder you will do ListNodes or equivalent inits path

You hit acontainer type then you can know its children that kind of a recursivealgorithm.

Anyway if youare on a decent enough WSAPI version or livelink server ,you can put a DBquery(Live Report) and call that Object for your WSAPI. Plenty of examplesincluding stuff I put in this forum.

If not I wouldjust put the above extract into a csv and read the variables in mind you it isvery easy to write a recursive algorithm if you know the root node.

It would beawesome if you could just share a recursive algorithm code here.

..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 Wed, Apr 29, 2015 at 6:17 AM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

How to retrieve nested categories from Category Volume/ Content Server Categories Posted bymakhan@ciber.com (Khan, Maqsood)On 04/29/2015 06:50 AM

Hi All,I'm new to OT CS and trying to retrieve following categories using CWS (Java).Category Structure in CS10.5:Category Volume |-- HR (Type: Category Folder) |-- HR Sub Category1 (Type: Category) |-- HR Sub Category2 (Type: Category) |-- Retail (Type: Category)Question: How can I retrieve nested categories of type "category" from CS by passing root catogry name/ id?I tried with below method call but it doesn't provide me with nested categories:CatWS = docManClient.getRootNode("CategoriesWS");
CatFolder = docManClient.getNodeByName(CatWS.getID(), "HR Categories");Appreciate any help or pointer.Maqsood Khan
[To post a comment, use the normal reply function]
Forum: Content Web Services Forum
Content Server: Knowledge Center

sıɹɥɔ

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi Maqsood,

To obtain the nodes in a container, e.g. within a Category Folder, you use the DocumentManagement methodlistNodes. So for your example:

CatWS = docManClient.getRootNode("CategoriesWS");
CatFolder = docManClient.getNodeByName(CatWS.getID(), "HR Categories");for (Node category : docManClient.listNodes (CatFolder, true))
System.out.println (category.getName());

Hope this helps,

-chris

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Wednesday, April 29, 2015 4:17 AM
To: eLink Recipient
Subject: How to retrieve nested categories from Category Volume/ Content Server Categories

How to retrieve nested categories from Category Volume/ Content Server Categories

Posted by makhan@ciber.com (Khan, Maqsood) On 04/29/2015 06:50 AM

Hi All,I'm new to OT CS and trying to retrieve following categories using CWS (Java).Category Structure in CS10.5:Category Volume |-- HR (Type: Category Folder) |-- HR Sub Category1 (Type: Category) |-- HR Sub Category2 (Type: Category) |-- Retail (Type: Category)Question: How can I retrieve nested categories of type "category" from CS by passing root catogry name/ id?I tried with below method call but it doesn't provide me with nested categories:CatWS = docManClient.getRootNode("CategoriesWS");
CatFolder = docManClient.getNodeByName(CatWS.getID(), "HR Categories");Appreciate any help or pointer.Maqsood Khan

sıɹɥɔ

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

I wasn't sure whether the original poster wantedall categories from the Categories Volume or only those he was showing in his example. I assumed the latter.

In case he does want all then an example of the recursive approach is:

privatestatic List<Node>getAllCategories(DocumentManagement docMan) {

     List<Node> allCategories = new ArrayList<Node>();
     addSubNodes(allCategories, docMan.getRootNode("CategoriesWS"), docMan);

     return allCategories;
}

privatestaticvoidaddSubNodes(List<Node> nodes, Node parent, DocumentManagement docMan) {

     for (Node child : docMan.listNodes(parent.getID(), true)) {
          if (child.isIsContainer())
               addSubNodes(nodes, child, docMan);
          else
               nodes.add(child);
     }
}

I wanted to mention that in general it's rarely a good idea to introduce database querying to CWS programs when api methods exist: it introduces security issues e.g. permission checking is difficult to do with only native SQL, and it introduces management issues e.g. the LiveReports now exposing information need to be properly access-controlled.

(I know you know all this Appu; I just wanted to point this out to someone new to CWS. As usual your post is full of valuable information!)

Thanks,

-chris

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Wednesday, April 29, 2015 5:21 AM
To: eLink Recipient
Subject: Re How to retrieve nested categories from Category Volume/ Content Server Categories

Re How to retrieve nested categories from Category Volume/ Content Server Categories

Posted by eLink On 04/29/2015 08:19 AM

Each category has a subtype=131 and if it is a category folder it has a subtype 132 select *from dtreewheresubtype=133 //Gives you category Volume this is your docManClient.getRootNode("CategoriesWS");

So in a oracleconnect by construct one can do this level is a pseudo column in oracle. Note if you are SQLserver(connect by is a CTE in SQLserver) or Oracle and your livelink is very new theTable dtreeancestors contain the parent /child relation of the node. It will run very fast as well. Check the LR forum to find dtreeancestors queries aplenty. selectname,dataid,subtype,levelfromdtreeconnectbyprior dataid=parentidstartwith dataid=(select dataid fromdtreewheresubtype=133); 132 also a 131 need not be in a category folder or volume as well. Why am I saying this in a WR forum? If you purely want to keep it in WSAPI code you will hit the volume and for each category folder you will do ListNodes or equivalent in its pathYou hit a container type then you can know its children that kind of a recursive algorithm.Anyway if you are on a decent enough WSAPI version or livelink server ,you can put a DB query(Live Report) and call that Object for your WSAPI. Plenty of examples including stuff I put in this forum.If not I would just put the above extract into a csv and read the variables in mind you it is very easy to write a recursive algorithm if you know the root node.It would be awesome if you could just share a recursive algorithm code here.

..appu appnair appunair
Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Wed, Apr 29, 2015 at 6:17 AM, eLink Entry: Content Web Services Forum<otdncontentwebservices971forum@elinkkc.opentext.com> wrote:
How to retrieve nested categories from Category Volume/ Content Server Categories

Posted by makhan@ciber.com (Khan, Maqsood) On 04/29/2015 06:50 AM

eLink User

Well in my defense usually these web services programmers have no good samples and they necessarily do not work day in day out on livelink like some of us do.I have seen them making very complicated efforts to do things .A typical WR/WF response is less than 2 hrs whereas a development question always goes un-answered for days if not months.So when I post some albeit stu*** code people like you take the effort to post much better code so it benefits the community.Kind of my baiting technique....

I doubt if I would be able to write such kind of beautiful code but I try and learn form the community .

..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 Wed, Apr 29, 2015 at 11:08 AM, eLink Entry: Content Web Services Forum <otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

RE Re How to retrieve nested categories from Category Volume/ Content Server Categories Posted bycwebster@opentext.com (Webster, Chris)On 04/29/2015 12:08 PM

I wasn't sure whether the original poster wantedall categories from the Categories Volume or only those he was showing in his example. I assumed the latter.

In case he does want all then an example of the recursive approach is:

private
static List<Node>getAllCategories(DocumentManagement docMan) {

     List<Node> allCategories = new ArrayList<Node>();
     addSubNodes(allCategories, docMan.getRootNode("CategoriesWS"), docMan);

     return allCategories;
}

privatestaticvoidaddSubNodes(List<Node> nodes, Node parent, DocumentManagement docMan) {

     for (Node child : docMan.listNodes(parent.getID(), true)) {
          if (child.isIsContainer())
               addSubNodes(nodes, child, docMan);
          else
               nodes.add(child);
     }
}

(I know you know all this Appu; I just wanted to point this out to someone new to CWS. As usual your post is full of valuable information!)

Thanks,

-chris

Re How to retrieve nested categories from Category Volume/ Content Server Categories

Posted by eLink On 04/29/2015 08:19 AM

..appu appnair appunair

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

On Wed, Apr 29, 2015 at 6:17 AM, eLink Entry: Content Web Services Forum<otdncontentwebservices971forum@elinkkc.opentext.com> wrote:

How to retrieve nested categories from Category Volume/ Content Server Categories Posted by makhan@ciber.com (Khan, Maqsood) On 04/29/2015 06:50 AM

Hi All,I'm new to OT CS and trying to retrieve following categories using CWS (Java).Category Structure in CS10.5:Category Volume |-- HR (Type: Category Folder) |-- HR Sub Category1 (Type: Category) |-- HR Sub Category2 (Type: Category) |-- Retail (Type: Category)Question: How can I retrieve nested categories of type "category" from CS by passing root catogry name/ id?I tried with below method call but it doesn't provide me with nested categories:CatWS = docManClient.getRootNode("CategoriesWS");
CatFolder = docManClient.getNodeByName(CatWS.getID(), "HR Categories");Appreciate any help or pointer.Maqsood Khan

[To post a comment, use the normal reply function]
Topic:	How to retrieve nested categories from Category Volume/ Content Server Categories
Forum:	Content Web Services Forum
Content Server:	Knowledge Center

Maqsood Khan

Thank you very much for your help, Chris & Appu!

I'll execute the code snippet and let you know guys on the result..

Maqsood Khan