How i can break the reference of two views in database

[Pravin Devidas Dasari]

I create the one view in database. When i add new view by clicking on plus(+) sign, A new view is created by replicating the first view data. And when made any changes in new view, It automatically reflect the same changes in first view. It has reference of each other. I want create multiple views in single database and that should be having separate structure and data. It should not have reference of any other view.

Could anyone assist me to archive this. Or share me the proper link for it.

Appreciation for your support in advance.

[Marc - Devoteam]

Hi @Pravin Devidas Dasari 

Welcome to the community.

A view is based on the source of the database.

I just tested it an yes my views initially are the same, but I can adjust views to my needs and changes aren't reflected in both or multiple views.

Can you create a new database an test, otherwise contact Atlassian Support

[Pravin Devidas Dasari]

Hi @Marc - Devoteam 

Thank you for reply.

I just tried same things, But facing the same issue. Can you provide the proper documentation for it. Meanwhile I will record my screen the send you.

[Pravin Devidas Dasari]

Hi @Marc - Devoteam 

Please find the below loom link for video.

https://www.loom.com/share/43888934b1554064a370f90cbf231b9c

Please assist me for it.

[Marc - Devoteam]

Hi @Pravin Devidas Dasari 

Views in a DB are there to display information from the DB in different ways.

Views don't contain separate data, so yes if you update data from the db and this is visible in another view, this is updated yes.

This is how a DB works, also in Oracle, SQL or other.

If you have a table of data and create o view of this table, this view contains the data from the table, if you change the table the view is changed as well.

[Pravin Devidas Dasari]

Hi @Marc - Devoteam 

Thank you for your quick response.

So, If I want to define the multiple tables in confluence database, then i need to create the confluence database for each table, Or is there any other way to define the multiple DB tables.

[Marc - Devoteam]

Hi @Pravin Devidas Dasari 

Yes, this is the route to take.

A Confluence db is a single table where you can create multiple views on the same table.

It's not a traditional database as SQL or postgres.