topic Re: SqlSyntax Error in Activiti 5.18 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sqlsyntax-error-in-activiti-5-18/m-p/228535#M181665 <HTML><HEAD></HEAD><BODY><SPAN>thanks, jbarrez</SPAN></BODY></HTML> Fri, 08 Jan 2016 01:40:23 GMT gangchu 2016-01-08T01:40:23Z SqlSyntax Error in Activiti 5.18 https://connect.hyland.com/t5/alfresco-archive/sqlsyntax-error-in-activiti-5-18/m-p/228533#M181663 Hi,&nbsp;&nbsp; I recently use HistoryService to get variables of a Execution, with following code&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; final List&lt;HistoricVariableInstance&gt; varlist =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; historyService.createHistoricVariableInstanceQuery().processInstanceId(processInstanceId)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .executionId(exe Wed, 06 Jan 2016 06:51:34 GMT https://connect.hyland.com/t5/alfresco-archive/sqlsyntax-error-in-activiti-5-18/m-p/228533#M181663 gangchu 2016-01-06T06:51:34Z Re: SqlSyntax Error in Activiti 5.18 https://connect.hyland.com/t5/alfresco-archive/sqlsyntax-error-in-activiti-5-18/m-p/228534#M181664 <HTML><HEAD></HEAD><BODY><SPAN>Indeed, you are correct. Fixed it here: </SPAN><A href="https://github.com/Activiti/Activiti/commit/68c02f75040af0501f04737380dcbbdc63edce3f" rel="nofollow noopener noreferrer">https://github.com/Activiti/Activiti/commit/68c02f75040af0501f04737380dcbbdc63edce3f</A></BODY></HTML> Thu, 07 Jan 2016 11:36:13 GMT https://connect.hyland.com/t5/alfresco-archive/sqlsyntax-error-in-activiti-5-18/m-p/228534#M181664 jbarrez 2016-01-07T11:36:13Z Re: SqlSyntax Error in Activiti 5.18 https://connect.hyland.com/t5/alfresco-archive/sqlsyntax-error-in-activiti-5-18/m-p/228535#M181665 <HTML><HEAD></HEAD><BODY><SPAN>thanks, jbarrez</SPAN></BODY></HTML> Fri, 08 Jan 2016 01:40:23 GMT https://connect.hyland.com/t5/alfresco-archive/sqlsyntax-error-in-activiti-5-18/m-p/228535#M181665 gangchu 2016-01-08T01:40:23Z