How to change issue assignee to a value from a custom field in JIRA
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Due to previous requirements, you might have the person assigned to work on an issue in a custom field instead of in the built-in assignee field. The following queries can be used to update the assignee with the value from the custom fie.d
Solution
Find the custom field id that corresponds with the custom field you are using for assignee:
1select id, cfname from customfield;Update the assignee
1 2 3 4 5update jiraissue set assignee = customfieldvalue.stringvalue from customfieldvalue where jiraissue.id = customfieldvalue.issue and customfieldvalue.customfield = <id from above>;Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Was this helpful?