rephrase question: grouping and sub grouping

["Bisht Anand" <Anand.Bisht@capco.com>]

Title: rephrase question: grouping and sub grouping

Hi All,

It’s me again; earlier question was not in proper phrase, so here I have rephrase again.

I need to associate the parent child grouping and sub grouping; I have renamed the id to parent to understand better.

 

Below xml result is expected as:

·       Top
o       Level – 1
§       Level – 1:1
§       Level – 1:2
o       Level – 2
§       Level – 2:1
·       Level – 2:1:1
·       Level – 2:1:1:1
§       Level – 2:2

<root>

       <Table>

             <folder_id>0</folder_id>

             <parent_id>0</parent_id>

             <folder_name>Top</folder_name>

       </Table>

       <Table>

             <folder_id>1</folder_id>

             <parent_id>0</parent_id>

             <folder_name>Level - 1</folder_name>

       </Table>

       <Table>

             <folder_id>2</folder_id>

             <parent_id>1</parent_id>

             <folder_name>Level - 1:1</folder_name>

       </Table>

       <Table>

             <folder_id>3</folder_id>

             <parent_id>1</parent_id>

             <folder_name>Level - 1:2</folder_name>

       </Table>     

       <Table>

             <folder_id>4</folder_id>

             <parent_id>0</parent_id>

             <folder_name>Leve - 2</folder_name>

       </Table>     

       <Table>

             <folder_id>5</folder_id>

             <parent_id>4</parent_id>

             <folder_name>Level - 2:1</folder_name>

       </Table>

       <Table>

             <folder_id>6</folder_id>

             <parent_id>5</parent_id>

             <folder_name>Level - 2:1:1</folder_name>

       </Table>

       <Table>

             <folder_id>7</folder_id>

             <parent_id>6</parent_id>

             <folder_name>Level - 2:1:1:1</folder_name>

       </Table>

       <Table>

             <folder_id>8</folder_id>

             <parent_id>5</parent_id>

             <folder_name>Level - 2:2</folder_name>

       </Table>

</root>

Thanks and regards

Anand Singh Bisht

Capco

O:      +91 80 5199 7200

F:      +91 80 5199 7201

M:              +91 98864 97309

E:              anand.singh@capco.com 

W:      www.capco.com

************************************************************************
The information in this email is confidential and is intended solely
for the addressee(s).
Access to this email by anyone else is unauthorized. If you are not
an intended recipient, please notify the sender of this email
immediately. You should not copy, use or disseminate the
information contained in the email.
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Capco.

http://www.capco.com/

************************************************************************