activti custom workflow and the database interactions

[chandrareddy]

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 and store the form data into it .. how can i achieve this using java backed webscripts ??
or any other alternatives available to achieve this ??

Any help will be appreciated.

Thanks in advance

Chandra

[mrogers]

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.

[chandrareddy]

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

[darkredd]

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