Need to remove duplicate values under list collector field "Can Read" in knowledge table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 03:08 AM
Hi All,
How do we remove duplicate values under list collector field "Can Read" in knowledge table.
There are 2000+ articles where a field "Can Read" has multiple duplicate values added somehow.
How to write a script and cleanup the duplicate values for the field "Can Read" and have only unique values.
Sample picture attached
Please help with the script.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 08:42 AM - edited 10-18-2022 08:53 AM
A Glide List field can contain more than one reference to the same object. While this is can only be done when the Glide List field is populated or updated via a script is it still possible and not an uncommon bug.
As the underlying value of a Glide List field is a comma separated string of sys_id's true duplicate values would mean that the list field contains the same sys_id more than once. That would not indicate that there are two objects in the referencing table with the same display value.
