Question

Unique constraint in entity

0

Hello, How to create a two fields unique constraint for an entity? I have 2 attributes which together should be a unique key in db – how to set it in Mendix?

asked 2021-09-29

Michal Pawlikowski

2 answers

1

Use a before commit microflow that checks the combined values and give a response back if the combination already exist.

Regards,

Ronald

answered 2021-09-29

Ronald Catersels

Shekhar Tyagi · Accepted Answer · 2021-09-29

Besides, what Ronald suggested, you could create one more attribute, which should be a calculated attribute formed by the concatenation of the two attributes. You can make this attribute as unique. You would still need to use the before commit event to calculate this field.