Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,455,380
Community Members
 
Community Events
175
Community Groups

How to mass change particular requirement in Bamboo Plans

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

1 answer

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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events