topic Re: Interaction with PostgreSQL using Share-workflow form. in Alfresco Archive

Interaction with PostgreSQL using Share-workflow form.

anand6105 — Thu, 31 Jan 2013 10:50:12 GMT

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

Re: Interaction with PostgreSQL using Share-workflow form.

afaust — Sun, 03 Feb 2013 14:54:03 GMT

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

Re: Interaction with PostgreSQL using Share-workflow form.

anand6105 — Mon, 04 Feb 2013 08:48:48 GMT

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.

Re: Interaction with PostgreSQL using Share-workflow form.

afaust — Thu, 21 Feb 2013 16:45:17 GMT

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