Can you suggest how can I do in this case?

Confluence User - 08 Mar, 2016

           The Corporation organization has 3 levels as 'P101 Business manager = department’ , P101-1 ‘Assistance business manager = sub department of P101’ and 'P101-1-1 Section manager = sub department of P101-1’ as show in table 1. In the future, if the organization change into 4 levels by adding 'P Managing Director = department as highlight in table2 and I need to move all information as I mention in table1 to be sub department of “P”. Can you suggest how can I do in this case?

 

 

Table 1

  

 

Table2

 

Level

Department ID

description

 

Level

Department ID

description

1

P101

Business Manager

 

1

P

Managing Director

2

P101-1

Assistance Business Manager

 

2

P101

Business Manager

3

P101-1-1

Section Manager

 

3

P101-1

Assistance Business Manager

 

   

4

P101-1-1

Section Manager

 

 

user;datalists

1


08 Mar, 2016
confluenceUser
confluenceUser

You will probably need to go into the database to set the column "parentId" to the new one (P) for P101.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print