topic Re: [Newbie] Custom propertie based on external database in Alfresco Archive

[Newbie] Custom propertie based on external database

atakacs — Tue, 30 Apr 2013 17:55:32 GMT

HiPretty new to Alfresco - please bear with me (although I believe to have some experience with ECM).I'd like to add (actually require) a custom property for documents in a space based on a list of possible values stored in an external SQL database.I muss confess that I am not sure how to achieve t

Re: [Newbie] Custom propertie based on external database

jpotts — Tue, 30 Apr 2013 22:53:53 GMT

What you are looking for is a constraint. A constraint is a content modeling construct that allows you to limit the values a property can have in a certain way. There are several out-of-the-box constraint types (like LIST, RANGE, MIN MAX, REGEX) but you can also define your own constraints.

This is an often-discussed thread. So search the forums for "constraint" and "database". You might also look at this wiki page: http://wiki.alfresco.com/wiki/Content_Model_Constraints

And, finally, there is an Add-On that claims to make it easy to add database-based constraints to your properties. It lives here:
https://addons.alfresco.com/addons/alfresco-metadbconnector-component

Enjoy,

Jeff

Re: [Newbie] Custom propertie based on external database

atakacs — Wed, 01 May 2013 06:11:25 GMT

Thanks for you input - appreciated !