Using IN clause in custom Activiti queries

neh — Wed, 04 Nov 2015 17:46:30 GMT

Hi,I was referring to http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/ to build a custom activiti query using the IN clause. When I pass a list of strings as the variableNames to the below MyTestMapper interface I get this errorrg.apache.ibatis.binding.BindingException: Pa

Re: Using IN clause in custom Activiti queries

neh — Wed, 04 Nov 2015 18:10:43 GMT

adding the mapper again with proper formatting:

<java>
public interface MyTestMapper {

@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_ in (#{variableNames})"
})
List<Map<String, Object>> selectTaskWithSpecificVariable(List<String> variableNames);

}

topic Re: Using IN clause in custom Activiti queries in Alfresco Archive

Using IN clause in custom Activiti queries

Re: Using IN clause in custom Activiti queries