Problem

As an admin, I need to retrieve programmatically the information that links a release to a given build key and vice versa even when there is no artifact published for a build.

Workaround

If the DB access is available, this information can be retrieved with the following query:

SELECT 
   CONCAT(dvp.plan_key, CONCAT('-',dvp.build_number)) build,
   dv.plan_branch_name,
   dv.name
FROM
   deployment_version dv
   LEFT JOIN dep_version_planresultkeys dvp
   ON dv.deployment_version_id = dvp.deployment_version_id