In this article we will provide you a ConstraintOnTableWithRecordLevelCheck Java implemtation that acts as a case insensitive uniqueness constraint.

You will have to activate the pathToField parameter in which you will specify the relative path from the table node to the string field you want to apply the constraint on (example: ./str).

The checkTable method will be called while performing a validation report at table level. It will go through all records of the table and return groups of records with the same field values (case insensitive).
The checkRecord method will be called in a record form context. It will forbid the user to save a record for which the field value is already existing in another record.

Please refer to the ConstraintOnTableWithRecordLevelCheck java documentation.

• Table validation report with errors 

• Blocked submit on record form