Pulling filtered entries from DB?

[Tim De Smet]

Hi all! I know the functionality is still in beta, but I was wondering if there's already a way to filter certain data pulled from a database, on a standard wiki page.

We're looking to shift from Google Sheets to Confluence for certain data used by the teams. The situation is as follows:

• We have partners that work with several of our teams, and that data is stored in several sheets. We want to set up the databases to replace these sheets.
• We then want to have a page per partner (or a selector, which would be better) to display the info from the several databases, for the selected partner.

So something like:

| Phone number | SELECT phone_number FROM partner_contact_info WHERE partner_id ='XYZ'; |

| Onboarding status | SELECT onboarding_status FROM partner_progress WHERE partner_id ='XYZ'; |

Views don't help in that regard. It would be great if we could indicate the value of partner_id and pull from all relevant databases, and display on the page where desired to have a quick overview.

Is this already a possibility? I tested somewhat but couldn't find a way to set this up. If not yet possible, is it in the roadmap for databases?

Thanks heaps!

[Kristian Klima]

Hi @Tim De Smet and welcome.

K15t's @Matt Reiner _K15t_ had a great Databases presentation at the last week's Atlassian Team 24 and as far as I remember, he touched upon the subject of aggregating data from multiple databases. 

Matt, will this end up on the K15t's YouTube channel?

[Matt Reiner _K15t_]

Yes @Kristian Klima, we've added some examples here.

[Matt Reiner _K15t_]

And also our recent livestream.