Database structure doesn’t have to be the UX.
When Jennifer called, during pilot, about the flat view list of network cameras too long to navigate. It’s a valid point.

The problem was it only applied to ONE layer 2 folder, it’s an outlier so changing the default view effect all the other folders.
- Layer 1: folder by product category
- Layer 2: document set by series
- Layer 3: documents of each series
- Layer 2: document set by series
There seem to be a per-location view setting in classic SharePoint, mentioned here and here, but doesn’t seem to work in modern SharePoint.
[X] change default view
[X] per-location view
My problem was thinking the user navigation from the database path. I’m thinking in folder structure, it’s linear.

The workaround is using page and web part, mentioned in this reddit thread. It reminds me:
- Like building a website, the information architecture doesn’t have to be the database architecture.
- Mind mapping, it’s linking to the entrance to the files.
