How to link databases in different spaces?

Question

I am currently playing around with Confluence databases in beta and for us especially the ability to aggregate data from different databases into one is especially interesting.

To test this, I set everything up, connected the databases and except for some minor hiccups it worked fine. Then I moved the aggregating database to another space, it also showed the same data, but it doesn't update anymore, if I change something in the other, linked, databases.

So apparently this data-link only works if the databases are in the same space, which is not clear from any descriptions or documentation and a big restriction of this feature.

Did anyone find a way to fix this or is this something that will be changed in future updates?

halldora.johannsdottir · Answer

Hi guys, do you know if it is now possible to link databases between two different spaces?  Or do you know if there is any workaround I could use?  I have two databases in each space and would like to extract data from both of them to use in a third space.

Kristian Klima_gtcuat · Answer

Thank you, Koloman, I'm gonna give it a try.

Koloman Pfeffer · Answer

Hi Kristian,

thank you for your answer.

So I didn't use the export/import feature, as I assumed, this only inserts static data and doesn't create a link between the two databases.

The way, I linked them was via the "entry link field", which let's me choose a database to link to and then chose the value I want to link from (basically just indicates, which row is chosen to display data from) and then the "entry details field" to chose which value I want to have displayed from the row I previously set in the "entry link field".

I hope this explanation makes sense - I had to tinker a bit with it, as the documentation on this feature is a bit lacking, but it worked perfectly when the databases were in the same space, but not anymore, when I moved the database that just displayed the data from two others.

Because of this, I think this "entry link field" is restricted to databases in the same space, but I hope they change this, because it would make this feature a lot more powerful.