queryProcessInstances

The queryProcessInstances operation returns the process instances that match the provided SQL query.

See also: queryProcessInstances

Web Service API example (SOAP):

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:proc="http://www.tibco.com/bx/2009/management/processManagerType">
   <soapenv:Header/>
   <soapenv:Body>
      <proc:queryProcessInstancesInput>
         <proc:query>SELECT ContactName FROM process WHERE INSTANCE.STATUS = 'ACTIVE'</proc:query>
         <proc:pageSize>10</proc:pageSize>
         <proc:attributeMap>
            <!--Zero or more repetitions:-->
            <proc:templateAttribute>
               <proc:name>ContactName</proc:name>
               <proc:type>string</proc:type>
            </proc:templateAttribute>
         </proc:attributeMap>
      </proc:queryProcessInstancesInput>
   </soapenv:Body>
</soapenv:Envelope>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Header/>
   <SOAP-ENV:Body>
      <queryProcessInstancesOutput xmlns="http://www.tibco.com/bx/2009/management/processManagerType">
         <processInstances>
            <processInstance>
               <customAttributes>
                  <customAttribute>
                     <name>ContactName</name>
                     <value>Ira Olson</value>
                  </customAttribute>
               </customAttributes>
            </processInstance>
            <processInstance>
               <customAttributes>
                  <customAttribute>
                     <name>ContactName</name>
                     <value>Walter Burfiend</value>
                  </customAttribute>
               </customAttributes>
            </processInstance>
         </processInstances>
         <pagingID>-1859988354</pagingID>
      </queryProcessInstancesOutput>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Service Connector API example (Java):

private void queryProcessInstancesExample()
{
  try
  {
    QueryProcessInstancesOutput instances = serviceConnectorInstance.queryProcessInstances(
     "SELECT * FROM process WHERE INSTANCE.STATUS = 'ACTIVE'", 0, null);
    System.out.println(instances);
  }
  catch (IllegalArgumentFault e)
  {
    // TODO Auto-generated catch block
    e.printStackTrace();
  }
  catch (OperationFailedFault e)
  {
    // TODO Auto-generated catch block
    e.printStackTrace();
  }
}