Summary

Bamboo users can mark plans as favorite. This article will cover how to find the favorite flag in the database.

Environment

All supported Bamboo versions.

Diagnosis

The favorite flag is technically a label, so table label is first place to look for:

select * from label where "name"=':favourite';

The removal of this flag is also recorded:

select * from label where "name"=':unmark-favourite';

The mapping is done in the table buildresultsummary_label, joined with the label id.

This table is mapped to the table build (plan definitions are stored there) through the build_id.

So, for example, let's say that we want to know all the users that marked the plan PR-PL as favorite. We will have to run:

select l.label_id, l.namespace from label l, buildresultsummary_label bl, build b
where l."name" = ':favourite'
and l.label_id = bl.label_id
and bl.build_id = b.build_id
and b.full_key = 'PR-PL';

(where PR-PL is the plan key)

The table buildresultsummary_label contains a column called "user_name" that also records the username. This column refers to the user that made the change, but not to the actual favoritism.