topic Getting runtime and historical variables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/getting-runtime-and-historical-variables/m-p/97851#M67390 <HTML><HEAD></HEAD><BODY><SPAN>I'm working on Mule and Activiti integration module, which should support both embedded and remote mode, i.e. interaction with remote Activiti server via REST API. One problem that I'm currently facing is that it seems to be no way to obtain runtime and historical variables via REST API. Am I missing something? So far my workaround is to connect to the data source that Activiti server uses and run SQL queries, but this is a pretty bad hack IMHO. My queries look like:</SPAN><BR /><BR /><SPAN>Get runtime variable: SELECT * FROM act_ru_variable WHERE PROC_INST_ID_ = ? AND NAME_ = ?</SPAN><BR /><SPAN>Get historic variable: SELECT * FROM act_hi_detail WHERE PROC_INST_ID_ = ? AND NAME_ = ? AND ACT_INST_ID_ = ?</SPAN><BR /><BR /><SPAN>Can this be done using REST? Or is there any other way to connect to remote standalone Activiti server and get these data?</SPAN><BR /><BR /><SPAN>Thanks a lot!</SPAN><BR /><BR /><SPAN>Forgot to mention: I'm using latest Activiti 5.8.</SPAN></BODY></HTML> Thu, 09 Feb 2012 14:38:53 GMT javaduke 2012-02-09T14:38:53Z Getting runtime and historical variables https://connect.hyland.com/t5/alfresco-archive/getting-runtime-and-historical-variables/m-p/97851#M67390 I'm working on Mule and Activiti integration module, which should support both embedded and remote mode, i.e. interaction with remote Activiti server via REST API. One problem that I'm currently facing is that it seems to be no way to obtain runtime and historical variables via REST API. Am I missin Thu, 09 Feb 2012 14:38:53 GMT https://connect.hyland.com/t5/alfresco-archive/getting-runtime-and-historical-variables/m-p/97851#M67390 javaduke 2012-02-09T14:38:53Z Re: Getting runtime and historical variables https://connect.hyland.com/t5/alfresco-archive/getting-runtime-and-historical-variables/m-p/97852#M67391 <HTML><HEAD></HEAD><BODY><SPAN>hi,</SPAN><BR /><BR /><SPAN>i guess i had a similar issue since i'm also using the REST API</SPAN><BR /><SPAN>i opended a bug for that: </SPAN><A href="http://jira.codehaus.org/browse/ACT-1075" rel="nofollow noopener noreferrer">http://jira.codehaus.org/browse/ACT-1075</A><BR /><BR /><SPAN>greets peter</SPAN></BODY></HTML> Thu, 09 Feb 2012 15:58:57 GMT https://connect.hyland.com/t5/alfresco-archive/getting-runtime-and-historical-variables/m-p/97852#M67391 prace 2012-02-09T15:58:57Z