Enforce Uniqueness on an attribute

To allow only unique values to be inserted in an attribute, indexing can be used. Enforcing uniqueness on an attribute can be achieved by enabling indexing on that attribute in database configuration and selecting the Enforce Uniqueness check box.

A more detailed tutorial about indexing can be seen here

Procedure:

In database configuration application, select the object which contains the attribute you want to enforce uniqueness.

e.g. I have a column STATUS in my object. To enable indexing on that click on new row.

Enter the unique name for that index e.g. STATUSTEST

Enforce Uniqueness: To make sure only unique values can be inserted in that field. Check the Enforce Uniqueness button. The existing data in that column must already be unique

In the columns view below.

add the columns you want to be indexed.

This does not require Admin mode to be turned on.

Save and configure DB

Enforce Uniqueness on an attribute – Maximo