How to freeze the database views?

Mohammed Sagheer October 10, 2024

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.

2 answers

1 vote
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 10, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 10, 2024

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

Mohammed Sagheer October 10, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 10, 2024

@Mohammed Sagheer 

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

2024-10-07_10-19-31.png

 

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.

2024-10-07_10-18-12.png

Mohammed Sagheer October 10, 2024

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.

0 votes
Kristian Klima
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 10, 2024

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 October 10, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events