nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do i assign a unique key in a database?

Ian Turner_57wldu

Hi,

I've been trialling the new database feature in confluence and I'm wondering how to automatically generate an ID for the entries that I make. I'm using it initially to track a list of issues/risks. Ideally these would get a reference number of the format I-nnn and R-nnn respectively, failing that just an incrementing number would do. But I can't find any options for setting values as unique or to autogenerate fields.

Is there any way of doing this?

thanks

Ian

Accepted answers

All comments

marc -Collabello--Phase Locked-

Hi @Ian Turner ,

Unfortunately Confluence Databases do not have this feature.

Ian Turner_57wldu

@marc -Collabello--Phase Locked- is there an existing feature request, if not how do i create one. Seems a fairly significant gap, a database without a unique key.

marc -Collabello--Phase Locked-

If I understand it correctly, Confluence databases are not a SQL like db, more of a type of data collection in a spreadsheet.

Ian Turner_57wldu

That doesn't quite compute for me.

If I have a list of things in a word table, spreadsheet or written on a piece of paper I'd number them. Confluence tables allow me to have an auto generated number column, admittedly they adjust if you add new rows but the principle is there.

In the confluence database there is no integer, closest I think I can get is a number format 1000.12. Plus confluence databases can reference each other - so foreign keys are effectively supported. But no primary key or reference value. Seems odd to me.

How am I supposed to uniquely identify the records in my database?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud