Bulk update certain changes on Tasks across multiple plans

Janakiraman S December 15, 2018

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
Daniel Santos
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 19, 2018

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
AUG Leaders

Atlassian Community Events