topic Re: Task Query limitation in Alfresco Archive

Task Query limitation

sebf — Mon, 30 Mar 2015 10:18:14 GMT

Hello, If a user has more than 1000 groups, ibatis select task query, not working.Indeed, <if test="candidateGroups != null && candidateGroups.size() > 0"> I.GROUP_ID_ IN <foreach item="group" index="index" collection="candidateGroups"

Re: Task Query limitation

jbarrez — Tue, 31 Mar 2015 08:57:22 GMT

Hmm this is the first time in the five years of Activiti that I see this error.

I'm not sure what a quick fix for this would be (except completely rewriting). Are you passing the groups all in the query or is this done automatically?

Re: Task Query limitation

sebf — Tue, 31 Mar 2015 09:00:35 GMT

This request was executed automatically by the .taskCandidateUser(userId) critieria.

Re: Task Query limitation

trademak — Wed, 01 Apr 2015 12:41:00 GMT

This is a limitation of Oracle IN queries, so there's not much we can do about this specific query. You could use your own NativeTaskQuery to prevent this specific issue.

Best regards,