topic Searching process instances in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237051#M190181 <HTML><HEAD></HEAD><BODY><SPAN>We anticipate that we will need to perform detailed searches across process instances. In particular, we would like to search for process instances matching against form field values and process variable values. I don't see that the existing GUI offers this level of searching. Also, I do see an API that allows me to search for tasks matching on field values but I don't see any API that allows me to search for process instances matching either field or process variables.</SPAN><BR /><BR /><SPAN>First, is there existing searching functionality that I've missed. Second, what is the potential and advisability of searching via direct SQL to the Activiti database?</SPAN><BR /><BR /><SPAN>Thanks!!</SPAN></BODY></HTML> Tue, 31 May 2016 14:48:27 GMT chuck_irvine 2016-05-31T14:48:27Z Searching process instances https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237051#M190181 We anticipate that we will need to perform detailed searches across process instances. In particular, we would like to search for process instances matching against form field values and process variable values. I don't see that the existing GUI offers this level of searching. Also, I do see an API Tue, 31 May 2016 14:48:27 GMT https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237051#M190181 chuck_irvine 2016-05-31T14:48:27Z Re: Searching process instances https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237052#M190182 <HTML><HEAD></HEAD><BODY><SPAN>Form fields are stored as process variables under the hood. So what you are looking for is the API where you can query on variables.</SPAN><BR /><SPAN>In the Java API, the ProcessInstanceQuery has this capability.</SPAN><BR /><BR /><SPAN>Activiti also supports 'native queries' which you can use to pretty much do as you please, with a small mybatis layer over it.</SPAN></BODY></HTML> Fri, 03 Jun 2016 07:43:29 GMT https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237052#M190182 jbarrez 2016-06-03T07:43:29Z Re: Searching process instances https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237053#M190183 <HTML><HEAD></HEAD><BODY><SPAN>Thanks very much for the information. I would be great if this functionality were exposed via a REST API.</SPAN></BODY></HTML> Fri, 03 Jun 2016 12:09:09 GMT https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237053#M190183 chuck_irvine 2016-06-03T12:09:09Z Re: Searching process instances https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237054#M190184 <HTML><HEAD></HEAD><BODY><SPAN>If it's for tasks/process instances, then that functionality is exposed via the API's.</SPAN></BODY></HTML> Mon, 20 Jun 2016 11:06:32 GMT https://connect.hyland.com/t5/alfresco-archive/searching-process-instances/m-p/237054#M190184 jbarrez 2016-06-20T11:06:32Z