how to get unique values in reference field

[kapilscs]

HI All,

I have a reference field and the values in back end table are duplicate. I want to show only unique values in the field. how to achieve this? Thanks in advance for any help.

Regards

Kapil Shinde

[Alikutty A]

Hi Kapil,

There is unique field on the table dictionary. You need to configure the field and check the unique flag on the related table.

For eg if CI name should be unique, configure the dictionary of Name field in cmdb_ci table and set the unique flag. This will ensure that there are no duplicate CI's with same name.

Note: You will have to fix existing records and this will be applicable for new records

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[Alikutty A]

This will be a permanent fix for your issue, A temporary fix will be adding an advanced reference qualifier to fix unique entries as mentioned by Ahmmed

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[kapilscs]

Thanks Alikutty,

my requirement is different, this field may contain duplicate values its just while displaying I need to show unique value. I have a table lets say table_x. It has column tier1 and tier2. Now the data that goes into this table is like below.

Tier1             Tier2

V1                     X1

V2                   X2

V1                   Y1

V2                     Y2

What I want is when user see the data from field Tier1 to select a value he should have presented with only unique values rather repeated values like V1 V1 V2 V2.

[Alikutty A]

Is Tier 1 a reference or choice field?

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response