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,294,887
Community Members
 
Community Events
165
Community Groups

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 Data Center on Kubernetes

Hi, If you are running self-managed environments and looking to adopt modern infrastructure, Bamboo Data Center can now be deployed in a Kubernetes cluster. By leveraging Kubernetes, you can easily...

940 views 3 8
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