Using database or reference data with Confluence - Input sensitive?

[Norbert Murzsa]

Hi dear community,

I'm looking for some macro-related guidance (or any help) on using reference data (stored in database or elsewhere) in Confluence. Like the excerp macro to include data from other Confluence pages.

I wish to create a data table (can be a Confluence table on a page with 3-5 fields) that I can reference from other Confluence pages using input sensitive search in the table records (like when you search for a user with typing the '@' character.

Any guidance on what to read, where to start?

Thank you for any guidance.

N

[Katerina Kovriga _Stiltsoft_]

Hi @Norbert Murzsa ,

We can suggest trying our Table Filter and Charts for Confluence app.

You can build a combined report from several multiple-row tables on other pages using the Table Excerpt/Table Excerpt Include macros.

The result table can be searched (filtered) with the help of the Table Filter macro.

To keep the report neat and easy-to-read, you'll be able to use pagination and hide the unwanted columns.

[Norbert Murzsa]

Hi Katerina,

Will have a look at your macro and see how I can test it in our non-prod. Then will come back. Thank you for your help and the information.

N

[Darja Majninger _K15t_]

Hi @Norbert

I think our newest app Orderly Databases for Confluence Cloud could be a great fit for you.

With this app you can create databases and reference them with the help of the Orderly Database macro on any page you like in form of a table. Alternatively, you can directly create a new database on a specific Confluence page. Here you can also adjust the view with the help of filters and database settings.

You can choose from a variety of common field types like text, page links (with automated page creation if required), users or selectable items. You can also link two databases by using the entry link field. 

Of course you can also reference specific entries or values from that database with the Orderly Entry or Value Macro on any other page in Confluence.

Maybe you want to give it a try, it's free for up to 10 users.
If you have any further questions, feel free to contact me!

Cheers,
Darja

[Norbert Murzsa]

Hi Darja,

Will have a look at your macro and see how I can test it in our non-prod. Then will come back. Thank you for your help and the information.

N

[David Guadalupe]

This was helpful for me as well, thanks!