You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.