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

[Doug Stone]

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 solution]

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.

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Yes, legally, you should use JCLI setFieldValue inside of a runFromIssueList action