queryProcessInstancesAlt

The queryProcessInstancesAlt operation returns the process instances that match the specified set of search criteria.

The queryProcessInstancesAlt operation is similar to the queryProcessInstances operation, except the SQL query is broken into its constituent parts.

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:queryProcessInstancesAltInput> <proc:select>INSTANCE.NAME,INSTANCE.ID,Issue</proc:select>
         <proc:where>INSTANCE.STATUS = 'SUSPENDED'</proc:where>
         <proc:orderBy>INSTANCE.START_DATE</proc:orderBy>
         <proc:pageSize>10</proc:pageSize>
         <proc:attributeMap>
            <!--Zero or more repetitions:-->
            <proc:templateAttribute>
               <proc:name>Issue</proc:name>
               <proc:type>string</proc:type>
            </proc:templateAttribute>
         </proc:attributeMap>
      </proc:queryProcessInstancesAltInput>
   </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>
               <processQName>
                  <processName>InternalHelpDesk</processName>
               </processQName>
               <id>pvm:0a12u</id>
               <customAttributes>
                  <customAttribute>
                     <name>Issue</name>
                     <value>Forgot password</value>
                  </customAttribute>
               </customAttributes>
            </processInstance>
         </processInstances>
         <pagingID>-94865740</pagingID>
      </queryProcessInstancesOutput>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Service Connector API example (Java):

private void queryProcessInstancesAltExample()
{
  try
  {
    // Query the active instances
    serviceConnectorInstance.queryProcessInstancesAlt("INSTANCE.NAME, INSTANCE.ID", "INSTANCE.STATUS='ACTIVE'",
"INSTANCE.START_DATE", 0, null);
  }
  catch (IllegalArgumentFault e)
  {
    // TODO Auto-generated catch block
    e.printStackTrace();
  }
  catch (OperationFailedFault e)
  {
    // TODO Auto-generated catch block
    e.printStackTrace();
  }
}