Hi,
I’m trying to find the location in the DB for the field(s) that stores the status of a project that is controlled via Bamboo Specs. Such as on the UI as shown below:
There is a db table vcs_location that has a xml_definition_data that captures all of the repository settings however the config bamboo.specs.enabled captures which projects have specs enabled as an option in the UI but it doesn’t differentiate between projects that are controlled by specs and those that aren’t but only have the setting enabled.
The bamboo version I'm using is: 7.1.1
Thanks.
The information you are looking for is contained in the PLAN_VCS_SPECS_SOURCE table. Here is a query that will return the Plan Id, Plan Key and RSS repository name. You can adapt it to your specific requirement.
SELECT S.PLAN_ID AS "Plan Id",
B.FULL_KEY AS "Plan key",
VL.NAME AS "RSS Repository"
FROM PLAN_VCS_SPECS_SOURCE S
JOIN BUILD B
ON B.BUILD_ID = S.PLAN_ID
JOIN VCS_SPECS_SOURCE V
ON V.VCS_SPECS_SOURCE_ID = S.VCS_SPECS_SOURCE_ID
JOIN VCS_SPECS_STATE VT
ON VT.VCS_SPECS_STATE_ID = V.VCS_SPECS_STATE_ID
JOIN VCS_LOCATION VL
ON VL.VCS_LOCATION_ID = VT.VCS_LOCATION_ID
Kind Regards,
Eduardo Alvarenga
Atlassian Support APAC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you @Conor O_Higgins
I've created a KB article that demonstrates that and more:
Regards,
Eduardo Alvarenga
Atlassian Support APAC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.