topic Re: When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ? in Alfresco Forum

When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ?

f4khri — Mon, 19 Mar 2018 08:29:38 GMT

Hi,I hope that the question is clear where can i find the infos writed by me to fill the form in usertask ?in which db table ?thank you

Re: When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ?

ryandawson — Mon, 19 Mar 2018 13:43:09 GMT

I guess you're using the engine embedded in your app. You should be able to access the submitted data as process variables or as form data - see Activiti/FormServiceTest.java at 6.x · Activiti/Activiti · GitHub for examples or Activiti/FormServiceTest.java at 5.x · Activiti/Activiti · GitHub if you're using v5.

Re: When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ?

ryandawson — Mon, 19 Mar 2018 13:50:00 GMT

In the DB either ACT_RU_VARIABLE or ACT_FO_SUBMITTED_FORM

Re: When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ?

f4khri — Mon, 19 Mar 2018 14:20:22 GMT

SELECT * FROM `act_ru_variable`

it works , thank you Ryan

Re: When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ?

f4khri — Mon, 19 Mar 2018 14:38:30 GMT

Hi again Ryan ,
like I said it works , but when the workflow ended , all usertasks fields filled by me which i can see it before in the act_ru_variable are deleted from the table ..
when the workflow end , all usertasks values of workflow are deleted ! why ? and how can I deny that
thank you

Re: When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ?

ryandawson — Mon, 19 Mar 2018 14:43:59 GMT

If it's not in ACT_FO_SUBMITTED_FORM then you can turn up the history level (Activiti User Guide ) and use ACT_HI_VARINST. You can see the database creation scripts in Activiti/modules/activiti-engine/src/main/resources/org/activiti/db/create at 6.x · Activiti/Activiti · GitHub

Re: When I fill a user task form fields with informations , where can I find the data ? where will the information be saved ?

f4khri — Mon, 19 Mar 2018 14:53:00 GMT

I don't have this table (ACT_FO_SUBMITTED_FORM)
I'm using the 5.22 version
So when the workflow is done , usertasks filled forms will be deplaced from act_ru_variable to ACT_HI_VARINST

thank you