How to change navigation option in sidebar globally for all spaces
This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Functional differences in Atlassian Cloud, the contents of this article cannot be applied to Atlassian Cloud applications.
Purpose
You can configure "Child page" or "Page tree" navigation in sidebar for each space as described in Configure the Sidebar.
However, it's not possible to configure the option globally for all spaces.
Solution
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Update BANDANA table with following SQL
If you want to set to "page tree",update BANDANA set BANDANAVALUE='<string>page-tree</string>' WHERE BANDANAKEY='sidebar.nav-type';
If you want to set to "child page",update BANDANA set BANDANAVALUE='<string>pages</string>' WHERE BANDANAKEY='sidebar.nav-type';
- Clear caches with General Configuration > Administration > Cache Management > Flush All