How to mass change particular requirement in Bamboo Plans

[Areg Vrtanesyan (Work)]

Hi Team

I am trying to mass update one of the lot of Bamboo Projects Plans Requirements and I am not sure how to do that.

Could you please help?

I was hoping that this could do a job but looks like that I can't update requirement by name.

acli bamboo --action updateRequirement --plan PRJ-PLAN --job JOB --id "something" --value "SOMETHING"

Error: Unable to convert 'something' to a Long.

Could you please advise?

Regards,
Areg

[Areg Vrtanesyan (Work)]

I have done following:

Run query against the database

SELECT
    public.build.full_key,
    public.requirement.requirement_id,
    public.requirement.key_identifier,
    public.requirement.match_value,
    '$acli bamboo-server --action updateRequirement --plan "' || split_part
    (public.build.full_key, '-', 1) || '-' || split_part(public.build.full_key, '-', 2) ||
    '" --job "' || public.build.buildkey || '" --id ' || public.requirement.requirement_id ||
    ' --value "<NEW VALUE>"' AS ACLI
FROM
    public.build
RIGHT OUTER JOIN
    public.requirement
ON
    (
        public.build.requirement_set = public.requirement.requirement_set)
WHERE
    public.build.build_type = 'JOB'
AND public.build.full_key LIKE '<PROJECT>-%'
AND public.requirement.key_identifier = '<requirement>'
AND public.requirement.match_value LIKE '<OLD VALUE>'
ORDER BY
    public.build.full_key ASC ;

Grab a result from ACLI column

Create shell file like

acli='/some path/atlassian-cli-7.x.0/atlassian.sh '
 
<ACLI column from SQL above>

Hope this could help