topic Re: TaskQuery when using custom Group/User Manager in Alfresco Archive

TaskQuery when using custom Group/User Manager

stbill79 — Thu, 12 Mar 2015 20:17:42 GMT

HiI've overridden the User/Group Manager and Factories similar to the LDAP example. This means that the DB tables ACT_ID_GROUP,USER, and MEMBERSHIP are empty.Essentially, I'd like to use the TaskQuery to grab a list of tasks for a given user; this would include all tasks where one of the following a

Re: TaskQuery when using custom Group/User Manager

jbarrez — Tue, 17 Mar 2015 09:22:26 GMT

You are correct, that does seem to be tightly (too tightly!) coupled with the membership table.
I would say a custom query is the only solution to solve it (or do multiple queries, but that's not nice)

Re: TaskQuery when using custom Group/User Manager

errorcv — Tue, 09 Jun 2015 19:58:22 GMT

Hi all,

I have the same situation with user/groups/membership.

How to write such custom query using Activiti API?

Thanks in advance

Re: TaskQuery when using custom Group/User Manager

stbill79 — Tue, 09 Jun 2015 21:11:45 GMT

I ended up doing something like this (obtain your groupIds for the user however you need to do it):

<java>
    @Transactional(readOnly = true)
    public List<Task> findCandidateTasks(User context) {
        Assert.notNull(context);
        String userId = context.getId();
        LOG.debug("Getting assigned, candidate user, and candidate group tasks for user: {}", userId);

        List<Task> candidateUserTasks = taskService.createTaskQuery().
                includeProcessVariables().
                taskCandidateUser(userId).
                orderByTaskCreateTime().asc().list();
        LOG.debug("Found: {} candidate user tasks for user: {}", candidateUserTasks.size(), userId);

        List<Task> assignedTasks = taskService.createTaskQuery().includeProcessVariables().
                taskAssignee(userId).orderByTaskCreateTime().asc().list();
        LOG.debug("Found: {} assigned user tasks for user: {}", assignedTasks.size(), userId);

        //Get your groupIds however you do it (identityService, custom method, etc.)
        List<String> groupIds = getGroupIdsByUserId(userId);

        List<Task> groupCandidateTasks = taskService.createTaskQuery().includeProcessVariables().
            taskCandidateGroupIn(groupIds).
            orderByTaskCreateTime().asc().list();
        LOG.debug("Found: {} group tasks for user: {}", groupTasks.size(), userId);

        Set<Task> candidateTasks = Sets.newHashSet();
        candidateTasks.add(assigneeTasks);
        candidateTasks.add(candidateUserTasks);
        candidateTasks.add(candidateGroupTasks);
        LOG.debug("got {} total group/user candidate tasks for user {}", candidateTasks.size(), userId);

        List<Task> candidateTaskList = Lists.newArrayList(candidateTasks);
        Collections.sort(candidateTaskList);
        return candidateTaskList;
    }

</java>

In my code, I actually created a TaskWrapper class to make sure both sorting works by creation date and equals uses the task id. YMMV.

Re: TaskQuery when using custom Group/User Manager

sendreams — Sat, 27 Feb 2016 12:30:29 GMT

I have the same situation with user/groups/membership. and i use or condition, but nothing task return. why?
List<Task> tasks = taskService.createTaskQuery()
    .processDefinitionKey("leaveProcess") // 后期要改
    .taskAssignee(user.getUsername())
    .or()
    .taskCandidateUser(user.getUsername())
//    .taskCandidateOrAssigned(user.getUsername())
    .list();

Re: TaskQuery when using custom Group/User Manager

sendreams — Sat, 27 Feb 2016 12:35:43 GMT

if i change the code to below, it can return a task list.
List tasks = taskService.createTaskQuery()
.processDefinitionKey("leaveProcess") // 后期要改
.taskAssignee(user.getUsername())
// .taskCandidateOrAssigned(user.getUsername())
.list();

i use 5.19.0.2

Re: TaskQuery when using custom Group/User Manager

xvm03 — Mon, 23 May 2016 07:47:42 GMT

how to write the custom query?my users and groups not in the same db

Re: TaskQuery when using custom Group/User Manager

jbarrez — Tue, 31 May 2016 09:15:36 GMT

the or() method is supposed to be used in a block with endOr(). Everything in the middle of that block will be or-ed.