- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-19-2018 06:11 AM
All,
I am attempting to change the 'Change Source' field on Change Requests to be a multi-select field to accommodate cases where the change source of a change request has more than one task type.
Thus far I have tried to change the Type of change source to 'choice' and 'list' but have not much luck in making the field act as a reference and multi-select field.
Any suggestions or advice would be greatly appreciated!
Solved! Go to Solution.
- Labels:
-
Change Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-19-2018 06:19 AM
Best practice is to avoid changing field types on existing fields. Instead, create a new field, migrate the data, and deactive the old field.
In your case, create a list field that references the task table, then copy over the sys_ids for the original field to the new list field. When that's done, update the dictionary entry on the reference field and set it to active=false.
The reason you don't want to do this for reference-> list field is because the length of the reference field is 40. The list field needs more than that if you want to store more than one sys_id, which you do. When you create a new list field, then length is plenty long (1024).
Let me know if you have any questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-19-2018 06:37 AM
You COULD do it via scripts background, but it means the script itself is "outside" the system. You'll write it and test it on dev, then test again by copy/paste on test, then finally apply it on prod. This is prone to human error.
Lately, I have been using Fix scripts to do this. They get captured by update sets/scoped app files, and move along from instance to instance so you maintain governance. Some organizations have an issue with allow admins to run scripts that are pasted in to scripts - background. Fix scripts is a great way to assess the script before it is run. Remember, the person who wrote the script, may not be the one who runs it in production. Personally, that makes me a bit uneasy. Fix scripts help me sleep at night. 🙂
Docs: Fix Scripts
