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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Bamboo

Bamboo 7.1 is here and is packed with value!

I'm happy to announce that Bamboo 7.1 has been released and it’s overflowing with awesome new features. Top-voted issues First and foremost, a bunch of JAC top voted issues has been delivered - y...

595 views 1 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you