Is there a way to replace text of multiple issues at once?

I'm looking for a way to replace text (a single word) in many Jira issues at once. I did not found any add-on which seems to be able to do that.

Perhaps it is possible by executing a jelly script? But I don't know jelly much.

I appreciate every hint to accomplish it without manipulating the database. The change history must not be updated.

Edit: The substitution should only be made on issues of a specific project. Additionally I have to consider all text fields (so far summary, description, comment and a custom field).

4 answers

1 accepted

0 votes
Accepted answer

Hi Jonas, the only way I can imagine replacing just a single word is via SQL queries. As in this example:

UPDATE jiraissue
   SET DESCRIPTION = REPLACE(DESCRIPTION,'<old_string>','<new_string>');
  • <old_string>: string to search on the field DESCRIPTION, which will be replaced for '<new_string>'.
  • <new_string>: string which will replace '<old_string>'

Cheers

Thanks Tiago, doing it via SQL query seems the only solution.

Upon closer look I also have to filter for a specific project and replace text in some more fields (see edit).

So far I would execute this query:

UPDATE jiraissue
    SET
         DESCRIPTION = REPLACE(DESCRIPTION,'&lt;old_string&gt;','&lt;new_string&gt;'),
         SUMMARY = REPLACE(SUMMARY,'&lt;old_string&gt;','&lt;new_string&gt;')
    WHERE PROJECT = 123456;

Do you know where to get the comments and custom field values (only for the specific project)?

Thanks

Hi Jonas,

This should give you the customfield values only for project with ID 10000:

select * from customfieldvalue where issue in (select id from jiraissue where project = 10000);

And this should return all comments:

select * from jiraaction where issueid in (select id from jiraissue where project = 10000);

I hope it helps.

Cheers

I know this is old thread but it might help others that end up here with googling the same issue.

I had the same question and found an easier way to do this.

You can export the issues you want to update into a csv file. Find and Replace the texts you want in Excel or other text editors.

Then re import the file back to Jira. The key is to import from the System > External System Import  (you need admin access) menu rather than the import on the issue menu, which non Admins can access.

Make sure you have the Issue Key column in your import file and the columns that you have text update. You don't need to map any of the columns that you didn't touch.

 

I've created a Python script to do search & replace across a set of JIRA issues via the REST API:

https://github.com/cboyke1/jira_search_replace

Came across this as I was searching for a solution to this problem. Your Python script saved me. Thanks for sharing, this is super useful!

Should I be adding this script under REST Endpoints under JIRA add-ons page and execute it?

@Chris Boyke I don't a have to install Phython on my work computer. Do you know about any similar solution using an VBA excel macro for example? Thanks. 

Very New Here :) (and to JQL and SQL. So please bear with me)

The above query seems to be meant for specific fields like a Description or Summary in JIRA, What if the find an replace I want to do is lives in multiple test steps? across several Acceptance Criteria. Its the same project though.

Also if I just want to delete a existing phrase would this work

DESCRIPTION = REPLACE(DESCRIPTION,'&lt;old_string&gt;','&lt;' '&gt;')

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 13, 2019 in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

624 views 0 12
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you