nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to change the existing data from Lower Case to Upper Case by Bulk update in Jira?

Mitch Mijares

I have alot of data inside the customer field and want to change all from lower case to upper case using Bulk update. Please advise

Accepted answers

All comments

Steven F Behnke

Bulk update can only 'set' field values. You'll not find an Upper Case or Lower Case method. The only option would be to use a scripting addon or use the REST API to read out the values, manipulate them, and put them back.

Gezim Shehu [Communardo]

My vote also goes for a scripting add-on. You do not need to purchase one, but highly suggested.

Simple script would do.

Steven F Behnke

Agreed -- This level of work would be difficult without either a plugin or a good knowledge of CURL to send API commands.

Mitch Mijares

Yes, that is what I thought. Alot of data is already loaded in the system via Bulk, then they realized now that some of the items are in lower case.

How about exporting the data > delete>modify >upload? I am new to Jira, so I am not sure if there is an export custom fields functions and mass delete.

Alexey Matveev

Hello,

You can do it with the Power Scripts add-on.

Your script would look like this:

string [] keys = selectIssues("yourcustomfield is not Empty");
for(string k in keys) {
   %k%.yourcustomfield = toUpper(%k%.yourcustomfield) 
}

Tom Vannostrand

I just had to do this and it works great:

Search for labels = blah OR labels = BLAH
You then can bulk edit to add a label called updatingallblahlabels or whatever so you don't lose the ability to find all your stories.
Then search for labels = updatingallblahlabels and bulk edit those to remove the labels blah and BLAH from all those. (This will actually delete both of those labels entirely which is nice because users won't see the "wrong" version of that label to pick from any more.)
then search for labels = updatingallblahlabels and bulk edit those to add the label Blah

Customize as needed.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-service-desk

jira-service-desk-cloud