topic Re: activti custom workflow and the database interactions in Alfresco Archive

activti custom workflow and the database interactions

chandrareddy — Fri, 14 Aug 2015 13:49:07 GMT

I am very new to alfresco and i was able to create the custom workflow for a requirement.I wanted to know where the share form data is stored when i fill in the values(or data)into the fileds that i have cteated in workflow share form.My requirement is: I want to create my own table in the database

Re: activti custom workflow and the database interactions

mrogers — Fri, 14 Aug 2015 16:32:50 GMT

In general when using alfresco or activiti you don't access the database directly. It is possible, a web script can do anything.

However the implementation is considered private and is subject to change so you should probably avoid it unless you really need it. That's why the approach is not recommended or documented.

Re: activti custom workflow and the database interactions

chandrareddy — Mon, 17 Aug 2015 06:59:41 GMT

Hi,

We have a requirement to retrieve the activiti workflow form data and showing into a Share custom dashlet for our internal leave application.

So please, is there any alternative solution to implement that service.

Thanks,
Chandra

Re: activti custom workflow and the database interactions

darkredd — Mon, 17 Aug 2015 09:34:37 GMT

Hello Chandra,

You do not really need to be digging into the Alfresco database to retrieve information about your workflows, there is a RESTful API that you can access to retrieve your data; and of course you will need to navigate through the responses to get what you really need. Here are some of the urls you may use:


1. var scriptURL='/api/workflow-instances?alf_ticket='+ticket;
2. var DropURL='/api/workflow-definitions?authority=admin&alf_ticket='+ticket;
‍‍‍‍

All these URLs return JSON data.

Read through this wiki for some detailed explanations: https://wiki.alfresco.com/wiki/Workflow_REST_API