cancel
Showing results for 
Search instead for 
Did you mean: 

Execute Custom SQL

pmittleman
Champ in-the-making
Champ in-the-making
For the example in the 5.16.1 User Guide:

@Select({
        "SELECT task.ID_ as taskId, variable.LONG_ as variableValue FROM ACT_RU_VARIABLE variable",
        "inner join ACT_RU_TASK task on variable.TASK_ID_ = task.ID_",
        "where variable.NAME_ = #{variableName}"
    })
    List<Map<String, Object>> selectTaskWithSpecificVariable(String variableName);  

How does one set the parameter value in the call to managementService.executeCustomSql(customSqlExecution);
1 REPLY 1

martin_grofcik
Confirmed Champ
Confirmed Champ
Hi,

complete example can be found here:
org.activiti.standalone.cfg.CustomMybatisMapperTest#testFetchTaskWithSpecificVariable

Regards
Martin