nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to freeze the database views?

unknown

When I create a view and embed the database on a different page, my expectation was that the values in the cells could not be changed and that the view would be a frozen snapshot of whatever the database holds currently after applying the filters.

The database entries are editable from pages were they are embedded. Isn't this a problem? I wouldn't want others to edit the entries in my database.

Accepted answers

All comments

Sebastian Krzewiński

Hi @[deleted]

If your database rely on other databases values will be changes. Only solution that I see to keep frozen values is to have new db without any link to other db.

Regards,

Seba

Kristian Klima_gtcuat

I'd argue that a frozen DB is undistinguishable from a table

Kristian Klima_gtcuat

Hi @[deleted]and welcome to the Community.

The very point of embedding any source is to ensure you have the latest version of that source available without the need to copy the actual content.

If you embed a presentation, or a video, and change them in their source, the changes would be visible. Same applies to excerpts, page include macros etc.

A solution would be to create a table from a DB at a desired point.

unknown

Tables do not offer the same visualization and filtering functionality as a database.

How do we protect database entries from being accidentally modified? Databases do not have a revision history too.

When I embed a view, the entire database is also shown, so I do not get the use case of having views.

unknown

True, if Views were read-only but still showing the latest values in database, would have solved my problem

Kristian Klima_gtcuat

@[deleted]

You can limit what's shown in the embedded database in the embed db macro settings.

So your embedded content would be limited: Compare the two vies - the first one with the above filter applied, under that there's the same DB embedded fully.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud