Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How are Confluence databases different from regular tables?

Michael Kogan March 5, 2024

Hello all,

 

I started playing with Databases (currently in Beta) but couldn't understand how they are different from regular tables. I have been using tables for years to track progress (e.g. Owner, Issues and Status columns), so what additional value are Databases supposed to bring?

 

Thanks

3 answers

1 accepted

1 vote
Answer accepted
Kristian Klima
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

@Michael Kogan 

Column: Pages, field type: Page link.

When I start typing, a list of pages appears, the one that I need typically appears on top after a couple of characters. Click, a Confluence link appears in the field.

Another column: Page details with Page link set to pages.

 

Michael Kogan March 6, 2024

Sorry, I mistakenly wrote "Page link field" instead of "Page status field". All what I described above happens when I try to add a "Page status" field type.

["Page link" field works fine.]

Kristian Klima
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

Oh, so for the Pages status field you should select Pages in the Page link option. Then it gets the corresponding values from the linked page.

You don't have to enter the actual link, the value is added automatically. It basically asks you 'where do I get this info from?'

Mind, the field remains empty if you don't use page status (which we don't as we use Comala Document Approval.

Michael Kogan March 6, 2024

Unfortunately, Page link option is empty ("No options" item appears and nothing more) :-( 

Kristian Klima
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

If you have one column set up with Page link, then you should see the following when populating other columns.

 

2024-03-06_16-06-55.png

Michael Kogan March 6, 2024

Yes, this worked!

Thanks a lot for your help and patience :-)

Like Kristian Klima likes this
Kristian Klima
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

@Michael Kogan You're welcome.

Databases is a great tool with a great potential, the more people use it, the better :)

2 votes
marc -Collabello--Phase Locked-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 6, 2024

Databases allow you to automatically "compute" and update fields.

Michael Kogan March 6, 2024

Care to provide some examples?

1 vote
Kristian Klima
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

@Michael Kogan 

Let's say that you have a page link in a column. DB can automatically populate fields like page status, owner, last updater, last update date... + there are filters.

For example, we use it to track pages that we use in learning.

So we have a course name, the date it was published, list of pages that are used in the course, and the last updated page. I can set up the filter to list the pages that were updated after the course went live.

Michael Kogan March 6, 2024

Thanks,

I tried to add a page link field (column). Strangely enough, I was requested to provide a link to a page as part of the field definition, which does not make sense: I was expecting a link per entry. Additionally, there is nothing in that drop-down to choose from, even though the link to the page is part of the database (resides in another column).

Suggest an answer

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

Atlassian Community Events