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
3 answers
2

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

answered
0

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

answered
0

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

answered