How to change navigation option in sidebar globally for all spaces
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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