Interaction with PostgreSQL using Share-workflow form.

[anand6105]

Hi,

Is there any possibility to provide some action on share-workflow-form.xml so that it can directly interact with PostgreSQL provided in Alfresco?
Let me explain with the help of a scenario:

I have a dropdown list of Games. e.g. Football, Cricket, Golf etc. and I have another dropdown which is based on the whatever game is selected. This dropdown consists of names players involved with this game i.e IF I select Football my second dropdown will be populated with names of Football players.
Now can I get this values directly from PostgreSQL. Is there any other approach to do this.

Thanks
Anand.

[afaust]

Hello,

I'd advise against using direct database queries / access for most use cases, and yours - as far as I know it from the post - would be one of them. Based on your description, you have a hierarchial set of data, e.g. players by type of sport. Depending on what other data you want to have associated, this sounds like a use case for a category tree in Alfresco data model. This would allow you to use a standard category control and save you the development effort (and maintenance issues) associated with a custom database access layer / operation.

Regards
Axel

[anand6105]

Hello AFaust,

Thanks for your reply. You are right i have to create a category tree in Alfresco data model. But how can I create action based category tree in my data model. can you explain with the help of an example?

Thanks
Anand.

[afaust]

Hello,

I'm afraid I don't fully understand the last question. You can create your category tree simply by using the Category Manager in Alfresco 4.x Share UI (or Explorer UI equivalent if you are up for a blast from the past), or by providing a bootstrap ACP / view XML. You can also create a category tree by using the <a href="http://wiki.alfresco.com/wiki/4.0_JavaScript_API#Classification_API">Classification JavaScript API</a>.

Regards
Axel