topic Re: Uniqueness constraint over content based on custom aspect properties in Alfresco Archive

Uniqueness constraint over content based on custom aspect properties

arpa1986 — Wed, 23 Apr 2014 02:27:16 GMT

HiI have defined a custom aspect that contains multiple properties. Is it possible to enforce a no duplicate content based in the properties of the custom aspect?Thanks,Andres

Re: Uniqueness constraint over content based on custom aspect properties

romschn — Wed, 23 Apr 2014 04:32:50 GMT

What is your requirement and what are you trying to implement?

Re: Uniqueness constraint over content based on custom aspect properties

arpa1986 — Wed, 23 Apr 2014 04:56:41 GMT

I configured a custom aspect, this aspect contains multiples properties. I need create an uniqueness constraint based in the properties of my custom aspect. When I upload a document, the uniqueness constraint should not allow upload document with the same properties of other documents.

Thanks

Andres

Re: Uniqueness constraint over content based on custom aspect properties

iamdhavaljoshi — Wed, 23 Apr 2014 07:33:59 GMT

I can suggest you work around to achevie the same. What you need to do is need to fire DB query on 'alf_node_properties' in query you can use qname_id in where clause and check if any node has already contains same property value for given qname_id. You can first find qname_id of your custom peroperty from 'alf_qname' table.

e.g.
SELECT * FROM alf_node_properties WHERE qname_id=2 AND string_value = '!!!000CD_123'

I am not sure about performance.

Thanks & Regards,
Dhaval Joshi
CIGNEX Datamatics

Re: Uniqueness constraint over content based on custom aspect properties

arpa1986 — Wed, 23 Apr 2014 21:12:00 GMT

Is it posible configure this uniqueness constraint into XML configuration of alfrescon installation?

Thanks,

Andres

Re: Uniqueness constraint over content based on custom aspect properties

iamdhavaljoshi — Thu, 24 Apr 2014 04:47:35 GMT

According to me there is no such configuration in xml for unqueness, You have write some custom code to implement it. But you can also try below given solution. I hope it will workl for you.

Solution:-

You can create custom table which will have all the fields for which you want no duplication. Fields are declared as not null and no duplicate. Create this custom table inside
Alfresco database.

Now implement nodeservice policy for create node and update node properties. Everytime when new node get created or property of node get updated, we need to push same inot custom table. Now we have
uniquness constraints implemented for each field so if there is duplicate entry it will throw duplicate value exception. Handle exception as per your business requirement.

According to me it's better possible solution.

Thanks & Regards,
Dhaval Joshi
CIGNEX Datamatics