Question

Primary and Secondary keys

1

I want to make a combination of two Attributes the key(unique) for the table. In mendix you can only make one attribute unique not a combination of two. At the moment i am using a micro flow(Before Commit) to verify there are no duplicates. This means each time i have to run through the whole Entity, will this cause performance issues later if the system gets big and busy! Is there a better way to do it.

asked 2010-12-22

Patrick Gerardi

3 answers

Pieter Van Gorp · Answer 1 · 2010-12-29

Hi all, I am also wondering whether there is any first-class support for specifying keys that are defined by multiple attributes and even by references (to-one association ends).

Is the "check for duplicates" query approach the only way to get the job done or is there dedicated support for this in Mendix?

Sincerely, and best wishes, Pieter Van Gorp

Michel Weststrate2 · Answer 2 · 2010-12-22

Ehh.. can't you just query for duplicates? Running through all objects sounds a bit slow indeed....

Michel Weststrate · Answer 3 · 2010-12-22

Ehh.. can't you just query for duplicates? Running through all objects sounds a bit slow indeed....