[Newbie] Custom propertie based on external database

[atakacs]

Hi

Pretty 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 this. Is it a job for Content Modeling ? Is there any "out of the box" tool to setup such a thing or does it require custom coding ?

Again sorry for asking what is most likely a trivial question but I'm most probably in need of some pointers to start in the right track.

Thanks in advance !

[jpotts]

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

[atakacs]

Thanks for you input - appreciated !