topic problems about execution query in multiinstance subprocess in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problems-about-execution-query-in-multiinstance-subprocess/m-p/197845#M150975 <HTML><HEAD></HEAD><BODY><SPAN>&nbsp;&nbsp; i design a process with activiti like this below,&nbsp; we uses activiti by activiti-rest api.</SPAN><BR /><SPAN>[img=640x400]</SPAN><A href="http://v1.freep.cn/3tb_140819113837fq1p512293.png" rel="nofollow noopener noreferrer">http://v1.freep.cn/3tb_140819113837fq1p512293.png</A><SPAN>[/img]</SPAN><BR /><BR /><SPAN>subprocess multiinstance is defined like this:&nbsp; ( slist = [1,2,3] )</SPAN><BR /><SPAN>&lt;code lang="xml" linenumbers="normal"&gt;</SPAN><BR /><SPAN>&lt;multiInstanceLoopCharacteristics isSequential="false" activiti:collection="slist" activiti:elementVariable="sid" /&gt;</SPAN><BR /><SPAN>&lt;/code&gt;</SPAN><BR /><BR /><SPAN>&lt;h1&gt;I prefered&lt;/h1&gt;</SPAN><BR /><SPAN>here , we have a intermediacatchingevent in multiinstance subprocess.&nbsp; </SPAN><BR /><SPAN>&lt;code lang="xml" linenumbers="normal"&gt;</SPAN><BR /><SPAN>&lt;intermediateCatchEvent id="sid-33B4590B-6209-4049-AD12-9D0F847980FA"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;messageEventDefinition messageRef="testMsg" /&gt;</SPAN><BR /><SPAN>&lt;/intermediateCatchEvent&gt;</SPAN><BR /><SPAN>&lt;/code&gt;</SPAN><BR /><SPAN>now, intermediacatchingevent is trigger by activiti-rest api from other system.&nbsp; but first i must query this execution in specified instance with sid = 2</SPAN><BR /><SPAN>but it will take at least two step to find this execution .&nbsp; first find this subprocess execution(n1) with sid = 2, then find execution with parent id (n1) and subscriptmessage event testMsg.&nbsp;&nbsp; Very complicated!</SPAN><BR /><BR /><SPAN>&lt;h1&gt;effective approach&lt;/h1&gt;</SPAN><BR /><SPAN>intermediateCatchEvent&nbsp; can be replace by a user task. like this:</SPAN><BR /><SPAN>&lt;code lang="xml" linenumbers="normal"&gt;</SPAN><BR /><SPAN>&lt;userTask id="wait_result" name="${sid}-wait_result" activiti:exclusive="false" activiti:assignee="kermit"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;documentation&gt;&lt;/documentation&gt;</SPAN><BR /><SPAN>&lt;/userTask&gt;</SPAN><BR /><SPAN>&lt;/code&gt;</SPAN><BR /><SPAN>attention :&nbsp; </SPAN><SPAN style="text-decoration: underline;">name="${sid}-wait_result"</SPAN><BR /><BR /><SPAN>this is more efficient, because we can find this user task execution by taskName: </SPAN><BR /><SPAN>taskService.createTaskQuery().taskName("2-wait_result")</SPAN><BR /><BR /><SPAN>&lt;h1&gt;question:&lt;/h1&gt;</SPAN><BR /><SPAN>1. is there a efficent way to find a intermediateCatchEvent execution in multiinstance subprocess,&nbsp; for example by name through activiti-rest api ( I didn't find it)?</SPAN><BR /><SPAN>&nbsp;&nbsp; I know that execution is stored in databases&nbsp; as tree structure, so i just query db myself ?&nbsp; or else that official supported method</SPAN><BR /><SPAN>2. i think usertask is used for triggered by human being,&nbsp; intermediateCatchEvent&nbsp; is more appropriate in this case that should be triggered by system.&nbsp; but complicated query is a big problem especially in multiinstance subprocess.&nbsp; Is there some advice ?</SPAN><BR /><BR /><SPAN>ps: i use activiti-5.15.1</SPAN><BR /><SPAN>thanks! </SPAN></BODY></HTML> Tue, 19 Aug 2014 05:50:44 GMT dalong 2014-08-19T05:50:44Z problems about execution query in multiinstance subprocess https://connect.hyland.com/t5/alfresco-archive/problems-about-execution-query-in-multiinstance-subprocess/m-p/197845#M150975 &nbsp;&nbsp; i design a process with activiti like this below,&nbsp; we uses activiti by activiti-rest api.[img=640x400]http://v1.freep.cn/3tb_140819113837fq1p512293.png[/img]subprocess multiinstance is defined like this:&nbsp; ( slist = [1,2,3] )&lt;code lang="xml" linenumbers="normal"&gt;&lt;multiInstanceLoopCharacte Tue, 19 Aug 2014 05:50:44 GMT https://connect.hyland.com/t5/alfresco-archive/problems-about-execution-query-in-multiinstance-subprocess/m-p/197845#M150975 dalong 2014-08-19T05:50:44Z Re: problems about execution query in multiinstance subprocess https://connect.hyland.com/t5/alfresco-archive/problems-about-execution-query-in-multiinstance-subprocess/m-p/197846#M150976 <HTML><HEAD></HEAD><BODY><SPAN>Indeed, user task is kinda misusing it (altough it will work).</SPAN><BR /><BR /><SPAN>It's not in the REST API, but the events can be fetched through the database (ACT_RU_EVT_SUBSCR), there is also a EventSubscriptionQueryImpl that you can use in your own Command (which means it's not part of the API)</SPAN></BODY></HTML> Tue, 19 Aug 2014 11:12:06 GMT https://connect.hyland.com/t5/alfresco-archive/problems-about-execution-query-in-multiinstance-subprocess/m-p/197846#M150976 jbarrez 2014-08-19T11:12:06Z