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

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Bulk update certain changes on Tasks across multiple plans

Hi,

Maybe this is a stupidic question.. Is there a way I can do kind of a bulk update across a task that is used across multiple Bamboo plans? 

I am not sure it is possible from the application, if not, can someone advise how this can be achieved from backend?

Thank you for the suggestions.

Janaki.

1 answer

0 votes

Hi Janaki,

Bamboo does not have a feature to bulk edit a given task across plans.
To do this you will need to work on the Bamboo database. The data you want to change is stored XML_DEFINITION_DATA column from BUILD_DEFINITION table.

This query will show you the data I'm talking about:

SELECT B.FULL_KEY, 
B.BUILD_TYPE,
BD.XML_DEFINITION_DATA
FROM BUILD_DEFINITION AS BD
JOIN BUILD AS B ON B.BUILD_ID = BD.BUILD_ID
WHERE B.BUILD_TYPE='JOB'
ORDER BY B.FULL_KEY

This data is stored in XML format and any change on it should be carefully performed. We don't want a malformed xml data blocking your plan configuration to be loaded.

This is what I would try:

  1. Backup your DB (for safety in case you need to roll back your change).
  2. Pickup a plan job which has a task to be modified.
  3. Copy the data from XML_DEFINITION_DATA to your text editor.
  4. Through the UI modify the task details to match your needs.
  5. Check how the change was applied to the database by comparing the new XML_DEFINITION_DATA information.
  6. Run an update using a "safe replace" (using a very specific replace and where clauses to only overwrite the right plans), to change all tasks you need.

I hope that can help you.

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...

684 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