How to display unique value in reference field

[Sachin G K1]

Hi All,

i have a reference field(ci class)>referencing "u_ci_class_lookup". This reference field is having duplicate records. how to remove this duplicates.

[Aman Kumar S]

You have to build ref qualifier, and through script include you need to pass on the list of unique ci class sys_ids.

[Sachin G K1]

Thank you

[Aman Kumar S]

@sachin g k

Feel free to Mark Correct, for convenience of future users.

[Musab Rasheed]

Hi Sachin,

Go through this link. Mark my answer as correct if that helps.

https://community.servicenow.com/community?id=community_question&sys_id=b073b02adb366380afc902d5ca9619e1