Can't set fields Unique

[Tony M]

Hi Everyone,

I Just can't set fields to Unique no matter what I do, I have the personalize_dictionary role, I created the field from scratch, I even indexed It as suggested in other thread but nothing works, fields are still getting duplicated even with the option checked. BTW the table was extended from CI

Related topics

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/field-administrat...

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

Thanks for any ideas

[Rishabh Jha]

Hi @Tony M ,

I hope you've verified the records in the table, and that the field doesn't have any existing duplicate value(s). If you can, maybe try to delete all the records (after taking a backup), and then import the data back again.

Also, if nothing works, you can write your own before insert/update business rule, to check for a duplicate value for the field, and if yes, abort the insert/update action.

Thanks & Regards,

Rishabh Jha

Aavenir (https://www.aavenir.com/)

[MrMuhammad]

Was there any duplicate data available prior to marking unique attribute as true?

[Tony M]

@Rishabh Jha  and @Muhammad 

Thanks Ill try the business rule since there are no duplicate values, guess its related to the CI table which was used to extend this custom table.

Do you guys know if there are any restrictions when extending tables to CI (configuration Item) table?

[MrMuhammad]

May be something I am not aware of 🙂