What happens when the ‘Unique constraint’ finds and issue in a process?

[MarkParticipant]

Hi,
can I use a Create activity that adds a value to an attribute with a unique constraint?
What happens when the value that I supply already exists?
Do you have any recommendations on how to use attributes with unique constraints in a process?

Thanks!

[LisaParticipant]

Hi Mark,

since it is not possible to enter unique values if they already exist, a process will fault if you try to add an already existing unique value using a Create Activity.
You can however use the Form Activity to enter and save the values directly into the database.
By using the Form, you will still get an error, but the process will not fault. You can then still use the same, running process to correct the value and save it.

I hope this answer is helpful.

Kind regards,
Lisa

[Author]

Posts