topic Execute Custom SQL in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/execute-custom-sql/m-p/196399#M149529 <HTML><HEAD></HEAD><BODY><SPAN>For the example in the 5.16.1 User Guide:</SPAN><BR /><BR /><SPAN>@Select({</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "SELECT task.ID_ as taskId, variable.LONG_ as variableValue FROM ACT_RU_VARIABLE variable",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "inner join ACT_RU_TASK task on variable.TASK_ID_ = task.ID_",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "where variable.NAME_ = #{variableName}"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; })</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; List&lt;Map&lt;String, Object&gt;&gt; selectTaskWithSpecificVariable(String variableName);&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>How does one set the parameter value in the call to managementService.executeCustomSql(customSqlExecution);</SPAN></BODY></HTML> Sun, 17 Aug 2014 14:02:12 GMT pmittleman 2014-08-17T14:02:12Z Execute Custom SQL https://connect.hyland.com/t5/alfresco-archive/execute-custom-sql/m-p/196399#M149529 For the example in the 5.16.1 User Guide:@Select({&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "SELECT task.ID_ as taskId, variable.LONG_ as variableValue FROM ACT_RU_VARIABLE variable",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "inner join ACT_RU_TASK task on variable.TASK_ID_ = task.ID_",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "where variable.NAME_ = #{variableName}"&nbsp;&nbsp;&nbsp; })&nbsp;&nbsp;&nbsp; List&lt;Map&lt;String, Sun, 17 Aug 2014 14:02:12 GMT https://connect.hyland.com/t5/alfresco-archive/execute-custom-sql/m-p/196399#M149529 pmittleman 2014-08-17T14:02:12Z Re: Execute Custom SQL https://connect.hyland.com/t5/alfresco-archive/execute-custom-sql/m-p/196400#M149530 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>complete example can be found here:</SPAN><BR /><SPAN>org.activiti.standalone.cfg.CustomMybatisMapperTest#testFetchTaskWithSpecificVariable</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Mon, 18 Aug 2014 08:00:59 GMT https://connect.hyland.com/t5/alfresco-archive/execute-custom-sql/m-p/196400#M149530 martin_grofcik 2014-08-18T08:00:59Z