Subspace plugin

[SergioC]

I need to set the parent of a space remotely. It is possible by inserting data in the appropriate tables of bbdd (os_propertyentry table)?

Thank you very much.

Sergio Contreras.

[Bill Martin · Accepted solution]

Hello Sergio,

Thank you for your request and for your interest in our plugin.

It is possible to set the parent space via HTTP Post remotely.
Use the URL: http://<Confluence_URL>/admin/subspace/changeparentspace.action
Method: POST
Request Header: Content-Type:application/x-www-form-urlencoded
Body: parentKey=<Key_of_the_parent_space>&key=<Key_of_the_space>

To set the parent space is also possible via database but we do not recommend to change any data in the database. It is very dangerous.

Do the following steps to set the parent space:

1. Get the id of the space description of the desired space:

   1. SELECT spacedescid FROM spaces WHERE spacekey='<SPACE_KEY>';

2. Set the parent space key in the space description of the desired space:

   1. INSERT INTO os_propertyentry (entity_name, entity_id, entity_key, 
      key_type, boolean_val, double_val, string_val, text_val, long_val, 
      int_val, date_val) VALUES 
      ('confluence_ContentEntityObject',<SPACE_DESCRIPTION_KEY>,'metadatakeys',6,FALSE,0,NULL,'Parent',0,0,NULL);
      INSERT
       INTO os_propertyentry (entity_name, entity_id, entity_key, key_type, 
      boolean_val, double_val, string_val, text_val, long_val, int_val, 
      date_val) VALUES 
      ('confluence_ContentEntityObject',<SPACE_DESCRIPTION_KEY>,'metadata.Parent',6,FALSE,0,NULL,'<PARENT_SPACE_KEY>',0,0,NULL);

3. Reset the application cache in the Confluence administration
   

   1. via "Confluence Admin" => "ADMINISTRATION" => "Cache Statistics" => "Flush All"

   2. via URL: http://<Confluence_URL>/admin/cachestatistics.action => "Flush All"

Please test these steps first on a test environment.

I hope this helps to clarify your question. If not, please do not hesitate to contact me again.

Greetings,

Bill Martin
Communardo Support

[SergioC]

Thank you very much Bill. 

Works correctly.

Best Regards.

Sergio Contreras