AnsweredAssumed Answered

Execute Custom SQL

Question asked by pmittleman on Aug 17, 2014
Latest reply on Aug 18, 2014 by martin.grofcik
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);

Outcomes