Sometimes a single, isolated database is not enough to model more complicated processes. For such cases, Orderly's advanced field types can come in handy by enabling you to link several databases with one another or reference details from other places in Confluence.

This guide introduces the more advanced field types of Orderly Databases and how to set them up. If you are new to Orderly Databases, check out our documentation on the basic field types.

Page Labels 

If you are a heavy label user in Confluence, then the page labels field will very likely be a practical field type for you. This field type displays all labels of a page that is referenced in the database within the page link field.

OptionsDescriptionScreenshot
Page link

Here you need to select the page link field for which's pages the label should be displayed.

Enable label editingTo make editing more dynamic, you can enable label editing here. This way, you can edit and create labels for the linked Confluence page directly from the database or database macro.

Page Status 

If you activated and defined page statuses in Confluence, you can reference those in your database easily as well. Just like the page labels field, it shows the status of the Confluence page linked in the page link field.

OptionsDescriptionScreenshot
Page link

Here you need to select the page link field for which's pages the status should be displayed.

Enable status editingIf you like to edit the page status dynamically out of the database or database macro, you can enable status editing here. 

Entry Details

Just like the entry link field, the entry link details field enables you to look up values from another database. The entry link details field automatically inserts all values of a chosen field from a different database based on an entry field you have added.

For example, if you have connected the two databases like described in the entry link field documentation, you can then reference all entries for a chosen field from the customer database within the customer projects database, e.g. the customers' location. 

OptionsDescriptionScreenshot
Entry link

For this option you need to already have added an entry link field in your database, referencing the entries from another database.

Then you can choose this entry link field as a reference base for your looked up values. 

Entry value

After adding the referenced entry link, you can select which field values you want to be looked up and this displayed in your currently edited database.

When you have chosen one, all values from this field will be automatically inserted. 

The backlink field is the complementary field type to the entry link one. Adding a backlink field to your database, it displays where the respective entry is referenced to in an entry link in another database. This can be very useful when you want to connect two databases in reciprocally, e.g. you want involved customers to be displayed in the projects database, but also see which projects a customer is part of. 

OptionsDescriptionScreenshot

Database

Here you can put in the database you want to scan for references to the individual entry. The references are then displayed for each entry.

Display

You can select whether you merely want to count how often the entry is referenced in the other database by selecting As number here. Alternatively, by selecting As link, you can also display the specific entries, where the currently edited entry is referenced

Jira Issue Details

Similar to the entry details field, the Jira issue details field enables you to display Jira field details from a linked Jira issue in the same entry.

For example, if you have linked a Jira issue in your entry, you can display its assignee in your database. If the assignee is changed in Jira, it will automatically be updated in your database.

OptionsDescriptionScreenshot
Jira issue

Choose a Jira issue field as a reference for the field details you're searching for. For this option, you must have added a Jira issue field to your database beforehand.

Jira field

After adding the referenced Jira issue, you can select which field details you want in your database.

Only standard Jira fields are shown in the dropdown. Custom fields can also be used, but only by typing the exact field name into the select field, then the item appears in the dropdown.

When you have chosen a particular field, all values will be automatically inserted. Do note that values in this field will be read-only, and they can only be edited from Jira.