How to freeze the database views?

[Mohammed Sagheer]

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.

[Sebastian Krzewiński]

Hi @Mohammed Sagheer 

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]

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

[Mohammed Sagheer]

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.

[Kristian Klima]

@Mohammed Sagheer 

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.

[Mohammed Sagheer]

Thanks for taking your time to answer in detail. My problem is that in the first View where I select a specific Entry, the entries are editable in the published page. I was hoping that the entries would be frozen and can only be updated from the acual DB itself.

[Kristian Klima]

Hi @Mohammed Sagheer 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.

[Mohammed Sagheer]

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