topic Re: Getting historical form data for a process instance in Alfresco Archive

Getting historical form data for a process instance

kleyo — Thu, 10 May 2012 05:37:15 GMT

Hi allI have a process which contains the user tasks, am able to successfully submit the user form using activiti api's and the variable data is stored in act_hi_details table successfully.am not able to retrieve the history data from the act_hi_details table.As per user guide the query is "historyS

Re: Getting historical form data for a process instance

c_arunrathnakum — Wed, 03 Oct 2012 10:44:28 GMT

Hello there,
I am struck too…
Need History Form Details…

Re: Getting historical form data for a process instance

kafeitu — Wed, 03 Oct 2012 11:05:09 GMT

Hi all

I have a process which contains the user tasks, am able to successfully submit the user form using activiti api's and the variable data is stored in act_hi_details table successfully.
am not able to retrieve the history data from the act_hi_details table.
As per user guide the query is
"historyService.createHistoricDetailQuery()
.variableUpdates()
.processInstanceId("123")
.orderByVariableName().asc()
.list()" which returns List<HistoricDetail>, but am not able to extract form data i.e, variable name and value from the historyDetails object.

thanks,
kleyo


List<HistoricDetail> list = historyService.createHistoricDetailQuery().processInstanceId(processInstance.getId()).list();
for (HistoricDetail historicDetail : list) {
    HistoricVariableUpdateEntity variable = (HistoricVariableUpdateEntity) historicDetail;
    System.out.println(variable.getName() + " = " + variable.getValue());
}

Re: Getting historical form data for a process instance

c_arunrathnakum — Wed, 03 Oct 2012 11:19:35 GMT

Hi kafeitu,
Thank u for yr immediate reply… I get the following Exception when i try to do that:

Exception in thread "main" java.lang.ClassCastException: org.activiti.engine.impl.persistence.entity.HistoricFormPropertyEntity cannot be cast to org.activiti.engine.impl.persistence.entity.HistoricVariableUpdateEntity

I m using activiti-5.10

Re: Getting historical form data for a process instance

kafeitu — Wed, 03 Oct 2012 12:09:22 GMT

Hi kafeitu,
Thank u for yr immediate reply… I get the following Exception when i try to do that:

Exception in thread "main" java.lang.ClassCastException: org.activiti.engine.impl.persistence.entity.HistoricFormPropertyEntity cannot be cast to org.activiti.engine.impl.persistence.entity.HistoricVariableUpdateEntity

I m using activiti-5.10

oh, sorry…

The result contains form datas, you should check type of Detail.


List<HistoricDetail> details = historyService.createHistoricDetailQuery().processInstanceId(processInstance.getId()).list();
  for (HistoricDetail historicDetail : details) {
   if (historicDetail instanceof HistoricFormPropertyEntity) {
    HistoricFormPropertyEntity formEntity = (HistoricFormPropertyEntity) historicDetail;
    System.out.println(String.format("form->, key: %s, value: %s", formEntity.getPropertyId(), formEntity.getPropertyValue()));
   } else if (historicDetail instanceof HistoricVariableUpdateEntity) {
    HistoricVariableUpdateEntity varEntity = (HistoricVariableUpdateEntity) historicDetail;
    System.out.println(String.format("variable->, key: %s, value: %s", varEntity.getName(), varEntity.getValue()));
   }
  }

If you want to query all form datas, you should add a filter only for form properties.

List<HistoricDetail> formDetails = historyService.createHistoricDetailQuery().processInstanceId(processInstance.getId()).formProperties().list();

Re: Getting historical form data for a process instance

c_arunrathnakum — Thu, 04 Oct 2012 13:57:59 GMT

It works… Thank u…