How do I set navigation display option for all spaces?

[Justin Stockton]

Is there a way to switch spaces to using the Page tree option instead of Child pages when displaying the navigation in the sidebar? I know I can set it on a space-by-space basis using the Space Tools, but we have about 60 spaces so I'd like to make the change globally if possible.

[Jonathan Maas]

You can do this by altering the database:

UPDATE BANDANA set BANDANAVALUE='<string>page-tree</string>' where BANDANAKEY like 'sidebar.nav-type' and BANDANAVALUE like '<string>pages</string>';

[Davin Studer]

Since 5.6, I believe, that is the default. But with your already created ones ... sorry, have fun clicking. 

[Lukas Knoch -Rumpelcoders-]

Hi, you can do this with a plugin. Do you have any experience with plugin development? Code for setting sidebars is 

bandanaManager.setValue(new ConfluenceBandanaContext(space.getKey()), "sidebar.nav-type", "page-tree");

[Lukas Knoch -Rumpelcoders-]

If you need further help feel free to ask.

[Justin Stockton]

Thanks for the response Lukas, but creating a plugin to set the sidebar navigation type seems a bit overkill. Maybe if we had a plugin of custom configs options already for our Confluence instance then this would be an simple solution.

[Lukas Knoch -Rumpelcoders-]

I think xou can do the same in database. Just look for bandana table.

[Lukas Knoch -Rumpelcoders-]

And just FYI, with a bit experience such a plugin takes about 2h to develop ;)