is it possible to use a sql-like syntax to update multiple jira records?

Question

Hi.  We have a field "Build Number".  I would like to change, for instance, all instances of 11.05.31 in the Build Number column to 110531.  I know we can make this change in Bulk Update, but that method would take far too long because there are many changes needed.  Is there a sql-like syntax that I might use?  I would simply change the syntax for each Build Number and execute.   Thanks.

JamieA · Accepted Answer

There is no "legal" method that is going to be faster than a bulk update.

You could use the jira CLI but that would be slower, or use a groovy script or plugin, but that's probably more work than you want. Fastest is sql but then you need to reindex jira.