topic Historic Process Variable Not Being Returned in Alfresco Archive

Historic Process Variable Not Being Returned

bcymet — Fri, 20 Jun 2014 19:29:24 GMT

Hi, I am using activiti 5.15.1 with a postgresql db. When I use the rest api to query historic process variables and I am getting all process variables but one back: https://blqadb3.ls.cbn/restactiviti/service/history/historic-variable-instances?processInstanceId=701{"data":[{"id":"718","processInst

Re: Historic Process Variable Not Being Returned

bcymet — Fri, 20 Jun 2014 20:06:50 GMT

The even weirder part is if I ask for the variable by name I do get the value I am looking for:

https://blqadb3.ls.cbn/restactiviti/service/history/historic-variable-instances?variableName=serialNumber&processInstanceId=701
<code>
{"data":[{"id":"727","processInstanceId":"701","processInstanceUrl":"https://blqadb3.ls.cbn/restactiviti/service/history/historic-process-instances/701','taskId':null,'variable':{'name':'serialNumber','type':'string','value':'A','scope':null}}],"total":1,"start":0,"sort":"variableName","order":"asc","size":1}
</code>

In the end this is what I really need but I am still confused as to why this variable isn't returned in the complete list.

Re: Historic Process Variable Not Being Returned

jbarrez — Fri, 27 Jun 2014 14:13:11 GMT

This confuses me too … there is no filtering being done in the query!

You could always enhance the log level on the engine side, and see which SQL query is being executed for that call.

Re: Historic Process Variable Not Being Returned

marcuss — Thu, 26 Feb 2015 13:30:29 GMT

I was having the same problem and found this topic. However, I was trying to get binary data and I found the solution in the Alfresco documentation: http://docs.alfresco.com/activiti/topics/getTheBinaryDataForAHistoricProcessInstanceVariable.html

Solution: GET history/historic-process-instances/{processInstanceId}/variables/{variableName}/data