Skills Management Pages with Databases

[Bernd Raesig]

I am evaluating confluence databases for a simple skills management system.

We would like to store and manage a set of skills with some details and then have maybe another database where we join people with one or more skills and their level of knowledge.

Usecases:

• there is a a skill profile for every user based on the skills database and the atlassian username, skill profile is available to all users and searchable by database fields
• a manager would be able to serach for a skill or a set of skills and gets results
• many more

For now I struggle a bit to join multiple skills inlding a skill-level with one person and report it nicely.

Has anyone here done similar things with confluence databases? Any advice is very welcome!

[Filip Callewaert · Accepted solution]

I would create one entry per skill per person and add a level field, with the skills in a separate, linked database. Single select, not multi.

- you can group per person > provides an overview of skills per person

- you can group per skill, and sort per level > provides you persons with that skill, to be sorted per level

- you can filter for skill sets (a profile) (define views)

[Bernd Raesig]

Thank you @Filip Callewaert ! Thats quite what I did for now 

Now trying to put the views and grouping together. I'll get there :-)

[Bernd Raesig]

very unfortunate is the fact that I cannot use database macros in confluence templates. We wanted to have the users skillset on a dedicated user profile page, but thats not gonna work. I voted for https://jira.atlassian.com/browse/CONFCLOUD-77965 already

[Filip Callewaert]

I'm quite confident that this feature will be released!

[Filip Callewaert]

@Bernd Raesig , I think I would have a separate (linked) database with the skills. It's much easier to manage and it prevents manual and repetitive input. 
Link the skills-database to a field, and then when selecting (select, not multi-select) a value, you can show related values from that other dbase too.

[Bernd Raesig]

We have 2 databases, "numbat skills" with all skills definitions and "numbat people skills" where we link the skills to people and add a level to it 

[Filip Callewaert]

Indeed - that's clear. I first did not guess that from your first screenshot!