topic Re: Dynamic constraint list integrity violation error in Alfresco Forum

Dynamic constraint list integrity violation error

abhay1980 — Fri, 29 Dec 2017 17:40:01 GMT

We are using dynamic constraint list with the id and name combination. After packet creation if any name change with respctive id and system trying to update existing packet. integrity violation error is coming. Is there any way to differentiate label and value in list

Re: Dynamic constraint list integrity violation error

afaust — Sat, 30 Dec 2017 11:05:24 GMT

Please first provide the name (and ideally link to) the addon you are using for the dynamic constraint list functionality. Since this is not a standard functionality of Alfresco, it is provided by some addon and in order to respond to the question we need to know which one, as they may have different implementations.

Re: Dynamic constraint list integrity violation error

abhay1980 — Sun, 31 Dec 2017 02:42:27 GMT

Thanks Axel ,

We are using ListOfValuesConstraint (Alfresco Data Model API)

Re: Dynamic constraint list integrity violation error

afaust — Mon, 01 Jan 2018 12:25:01 GMT

That type of constraint is not a "dynamic" constraint list. It is just a simple, predefined constraint list. And yes, it differentiates between label and value - the label is maintained via localisation of the model. You can see an example in the BPM Model localisation files.

Re: Dynamic constraint list integrity violation error

abhay1980 — Tue, 02 Jan 2018 15:53:36 GMT

Thank You Axel. This is very helpful. Our dropdown values(ID -Name ) is changing frequently. Could you please suggest some good dynamic constraint list functionality.

Re: Dynamic constraint list integrity violation error

afaust — Tue, 02 Jan 2018 17:58:33 GMT

So far I haven't seen "good" functionalities yet. A quick search via Google returns various results, and even a meta list of 5 addons.

With frequently changing drop down values you should be really careful about setting this up as a "constraint". If your list e.g. only includes the "currently selectable" values for UI convenience, then this may result in existing data becoming invalid and causing validation issues if old entries need to be touched again, as their old value may no longer be contained in the list.

Re: Dynamic constraint list integrity violation error

douglascrp — Wed, 03 Jan 2018 11:25:32 GMT

I have been using this one with success for years now GitHub - dgcloud/alfresco-value-assistance: Configurable value assistance module for Alfresco Share that allows picklist…