Is there a built in function that will check for an entire unique record?
Some fields have the possibility of repeating, however the entire record(all fields) should never be entered a second time.
Hi,
you can define unique constraints that span across multiple columns. So you can include all business columns in this constraint. Depending on the usage of soft delete, you have to include the deleteTs column as well.
In the entity editor in studio there is a tab called constraints, where you can define it.
Bye
Mario
1 Like
Thank you Mario, this is exactly what I needed and looked right past it!