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

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!

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,329 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot