CMDBuild Forum

feature request: allow multiple unique attributes combination

Old Versions
#1

Hi all!

It would be very cool, do the following.If a class has several unique attributes - then create a composite unique attribute (for example: CONSTRAINT u_constraint UNIQUE (id_a, id_b, id_c)).In order to a unique combination of these attributes, rather than each individual attribute.

#2

Did you get any clearity on this interesting request?

 

 

Previously Stepan wrote:

Hi all!

It would be very cool, do the following.If a class has several unique attributes - then create a composite unique attribute (for example: CONSTRAINT u_constraint UNIQUE (id_a, id_b, id_c)).In order to a unique combination of these attributes, rather than each individual attribute.

 

#3

At this moment it is not possible to define a composite unique attribute.
We can include it in our wish list .

CMDBuild Team

 

 

#4

Is it possible to do something on a database level? It would also require that the error handling is capable of dealing with this.

 

Previously Tecnoteca wrote:

At this moment it is not possible to define a composite unique attribute.
We can include it in our wish list .

CMDBuild Team

 

 

 

#5

You can define an "hidden" attribute, make it unique and set its value with a database trigger like this:

http://www.cmdbuild.org/forum/forum-in-english/908224516?b_start=0#561835818

CMDBuild Team

#6

Thank you for your cooperation.

 

Previously Tecnoteca wrote:

You can define an "hidden" attribute,  make it unique and set its value with a database trigger like this:

http://www.cmdbuild.org/forum/forum-in-english/908224516?b_start=0#561835818

CMDBuild Team