I'm an admin, but do not have direct access to the database to run SQL queries. Is there any other way I can bulk populate a new field with the value of an existing field?
Example: we have an Owner field that currently allows one name. We want to switch it to allow multiple names, but without database access, we can't change field types, so I've added a new field called Owners that's a multi-user picker. But we have hundreds of tickets, and updating them manually one by one would take way more time than I have. Is there any way to do the equivalent of this query, without database access?
UPDATE issue SET Owners = Owner
It will take some effort but totally do-able.
Here are the steps:
1) Create the new multi-user field and add it to the applicable project.
2) Use a list of the users populated in the original user field of the project then manually bulk edit(clone) the same user name onto the new multi-user field.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG