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.
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
I'd argue that a frozen DB is undistinguishable from a table :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
True, if Views were read-only but still showing the latest values in database, would have solved my problem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.