Migrate dates from user created field to system date field

philipf
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2024

Hello,

I have a custom field "Due Date", which shouldnt have been used but was.

I would like to update all of the tickets that use 'Due Date', to use the system field 'Due date'

---

Is there a way for me to take all of the dates in 'Due Date' and transpose them to the system field 'Due date'?

2 answers

2 accepted

1 vote
Answer accepted
Avinash Bhagawati _Appfire_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 15, 2024

Hi @philipf Good day!

Please try below approach for your requirements.

1. Create a self transition in the workflow ( Self transition will transition the issue to any status to itself and this ensures there no change in the status).

2. Add a post function to copy the field from Custom field to system field. Here you can make use of any workflow app like JSU, JMWE to add a post function.

3. Publish the workflow.

4. Construct a JQL with required issues where you would like to migrate the data 

5. Perform bulk transition on the issues.

Note as bulk transition limited to 1000 issue for single iteration, you may need to do multiple iteration based on number of issues.

I hope this helps you !

Thanks,

Avinash 

0 votes
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 15, 2024

Hello @philipf 

Another option is to create an Automation rule to gather the issues you want to update and use the Edit Issue action to copy the data from one field to the other.

You could use a Schedule trigger with a JQL statement that selects the issues where your field contains data and the system field is empty.

There are limits on how many issues can be processed in an automation rule, so you may have to run the rule multiple times.

https://support.atlassian.com/cloud-automation/docs/automation-service-limits/

philipf
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 21, 2024

thank you so much

Like Trudy Claspill likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events