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

This widget could not be displayed.

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

This widget could not be displayed.

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.

 

This widget could not be displayed.

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?

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

144 views 2 0
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