Completed Worflows by user

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

mangar

I am after a list of WorkflowItem by user. (Who started the workflow)  I can get them by

    workflowService.getCompletedWorkflws();
‍‍‍

and then loop through for the getItiator(),  but that seems like that's wrong for very large amount of workflows.

So I try a workflow query like this:

      Map<QName,Object> map = new HashMap<QName,Object>();
      map.put(QName.createQName(AlfrescoModel.BPM_NAMESPACE,"creator"), userId);
      WorkflowInstanceQuery query = new WorkflowInstanceQuery();
      query.setActive(false);
      query.setCustomProps(map);
      List<WorkflowInstance> workflowList = workflowService.getWorkflows(query);
‍‍‍‍‍‍‍‍

this is always returning 0 workflows.

WHat am I doing wrong?  Is there a good tutorial on the workflow query?  The API documentation is NO help at all.

kaynezhang

Using

   Map<QName,Object> map = new HashMap<QName,Object>();
   map.put(QName.createQName(AlfrescoModel.BPM_NAMESPACE,"creator"), userId);
   WorkflowInstanceQuery query = new WorkflowInstanceQuery();
   query.setCustomProps(map);
‍‍‍‍‍‍

will search workflow instances that have a global variable named {AlfrescoModel.BPM_NAMESPACE}creator and with value userId,it is not what you are looking for.
If you want to search workflow instances that  started  by some one,please do as below

    //First get a person node by user using PersonService.getPerson(String userName)
    NodeRef personNode = personService.getPerson(userId);
    //then define qname initiation search condition
    public static final QName QNAME_INITIATOR = QName.createQName(NamespaceService.DEFAULT_URI, WorkflowConstants.PROP_INITIATOR);
   Map<QName,Object> map = new HashMap<QName,Object>();
   map.put(QNAME_INITIATOR, userId);
   WorkflowInstanceQuery query = new WorkflowInstanceQuery();
   query.setCustomProps(map);
    // search 
      query.setActive(false);
      List<WorkflowInstance> workflowList = workflowService.getWorkflows(query);
‍‍‍‍‍‍‍‍‍‍‍‍‍