Execute Custom SQL
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-17-2014 10:02 AM
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);
@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);
Labels:
- Labels:
-
Archive
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2014 04:00 AM
Hi,
complete example can be found here:
org.activiti.standalone.cfg.CustomMybatisMapperTest#testFetchTaskWithSpecificVariable
Regards
Martin
complete example can be found here:
org.activiti.standalone.cfg.CustomMybatisMapperTest#testFetchTaskWithSpecificVariable
Regards
Martin
