Need help to copy custom field values to another for 120K issues

Question

Hi,

I was wondering if anyone from the community can help or give me a pointer to do copying custom field values to another custom field without having to keep clicking and rerun it every 100 issues in the Jira cloud.

I have around 120K issues that I need to copy one custom field to another in the same issue.  I am trying to use the ScriptRunner build-in script for copying field values. However, it only can do 100 issues at a time.  This is not a viable solution since it will take 1200 times to click the Run button to rerun the script. Each run can only process 100 issues and takes 240 seconds. That means it will take 80 hours continuously clicking the RUN button to rerun the script to complete all the issues.

Is there another way to automate this process?

Thank you for your help.

Regards,

Kent

Kent Chiu · Answer

Thank you Mykenna for your suggestion. I am not sure how we can limit the JQL result to a certain amount of issues to process such as 5000. I don't recall there is a conditional statement in JQL that limit the return result.

In JIRA Server, there is a setting where we can limit the JQL result. But I am not aware in JIRA Could.

Kent Chiu · Answer

Thank you Hannes for your suggestion. I'll take a look at JXL.

Mykenna Cepek · Answer

I would think that the built-in Jira Automation could help you do this.

By using a Manual Trigger, you can specify the JQL to identify a set of issues, and then operate on each of those issue.

Based on what I see, automation can process at most 50,000 issues. I wouldn't go that far, maybe target 5,000 to 10,000 per run, which still makes it feasible manually.

Be sure to review any other automation limits you might run into, based on your Jira plan.

I'd start with maybe 1000 to see how long it takes, and adjust to stay under the threshold for "rules that run too long and trigger throttling".