About unique column

yuta chiba
Kilo Contributor

Hi,mate.

I have questuion, About unique column.
I created original table.
It have "ip_address" column.
"ip_address" column have unique status, status is true.

But, ip_address duplexed.
Why, it duplexed.

Thank you.
yuta.find_real_file.png

7 REPLIES 7

Sai Kumar B
Mega Sage
Mega Sage

@yuta chiba 

1.) Uncheck the unique checkbox

2.) Clear instance cache

3.) Check the Unique checkbox

4.) Re-test

If still no luck upon proceeding with the above steps, You can try validating the uniqueness using the Business rule or You can raise the HI ticket on unique functionality failure.

Hi,

Thank you for advice.
I will try it.
Sorry, follow me again.

How do it ?,Sorry for the basic question
>2.) Clear instance cache

I think writing "cache.do" at file navigator, Collect it?

Thank you.

yuta.

Kalyani Jangam1
Mega Sage
Mega Sage

Hi,

Personalize Dictionary for that field. If the Unique checkbox is not on the Dictionary form, personalize the form layout for the Dictionary form and add it. Check it for your field, and update the Dictionary record.

Then a unique constraint will be enforced for that field. Note that the field must not have duplicate values already, or doing what I described will fail.

Hi,

Thank you your support.
I tried it, But not change statue.
By the way, correct bellow image it?

Thank you,
yuta.find_real_file.png