Monitor 10.11 | pub.monitor.process.instance Folder | pub.monitor.process.instance:getInstanceListWithFilter
 
pub.monitor.process.instance:getInstanceListWithFilter
Retrieves process instances that meet specified criteria. In addition to the criteria that you can specify with the pub.monitor.process.instance:getInstanceList service, with this service you can also use filters to limit the returned instances based on pipeline values logged at run time and filter fields assigned to the process model on which the instance is based.
Note:
Whether the search is case-sensitive or case-insensitive depends on how the underlying database (for example, Oracle, DB2, or SQL server) handles the queries that Monitor issues to obtain data.
Input Parameters
The following table lists the input parameters.
modelID
String Optional. Complete model ID used for the process instances you want retrieved. You can retrieve model IDs by invoking the pub.monitor.process.instance:getProcessList service and using the value returned in the processNames/PROCESSKEY output parameter. When you specify modelID, do not use the modelNameInput parameter.
modelIDSet
String List Optional. A set of complete model IDs used for the process instances you want retrieved. You can retrieve model IDs by invoking the pub.monitor.process.instance:getProcessList service and using the value returned in the processNames/PROCESSKEY output parameter. When you specify modelID, do not use the modelNameInput parameter.
modelNameInput
String Optional. Complete or partial model name used for the process instances you want retrieved. You can retrieve model names by invoking the pub.monitor.process.instance:getProcessList service and using the value returned in the processNames/PROCESSKEYDECODE output parameter. When you specify modelNameInput, do not use the modelID parameter.
instanceID
String Optional. Complete or partial instance ID for the process instances you want retrieved.
status
String Optional. The status of the process instances you want retrieved. The status you specify is matched against the most recently logged status. Use status if you want the list to contain all process instances of a single specified status. Specify the numerical value that represents the status. For a list of values you can specify, see Status Reference.
Note:
If you do not specify status or statusSet, the service returns process instances of all statuses.
statusSet
String List Optional. A set of statuses for the process instances you want retrieved. Use statusSet when you want the list to contain process instances of more than one specified status. For each status that you specify in statusSet, specify the numerical value that represents the status, as described above for the status parameter.
parentInstanceID
String Optional. Complete or partial instance ID for the parent process of the process instances that you want retrieved.
customID
String Optional. The full, user-defined ID for the process instances that you want retrieved. User-defined IDs are assigned by executing the pub.prt.log:logCustomID service.
dateCreated
String Optional. A date range for the process instances you want retrieved. The date range identifies the date of the most recent log entry for the process instances. If you use this parameter, do not use the fromDate or toDate parameter.
*Today Today
*Yesterday Yesterday
*In the last 7 days Within the last 7 days, including the current date.
*Last week Any day in the previous calendar last week (A week is Sunday through Saturday.)
*This week Any day in the current calendar week (A week is Sunday through Saturday.)
*Last month Any day in the previous calendar month
*This month Any day in the current calendar month
fromDate
String Optional. The start date of when data was logged for the process instances you want retrieved. The service retrieves process instances with entries logged on or after this date. Use the format YYYY-MM-DD HH:MM:SS. If you use this parameter, use toDate to specify the end date; do not use the dateCreated parameter when you use the fromDate and toDate parameters.
toDate
String Optional. The end date of when data was logged for the process instances you want retrieved. The service retrieves process instances with entries logged on or before this date. Use the format YYYY-MM-DD HH:MM:SS.
stepID
String Optional. The full ID of a step that was executed in the process instances you want retrieved. You can retrieve step IDs using the service. When you use this stepID parameter, you must also specify:
*The modelID parameter to identify the model in which to search for the specified step.
*The user or role parameters.
user
String Optional. To retrieve information about tasks, user on which to match (that is, user that performed a task). When you use this user parameter, you must also specify the modelID parameter.
role
String Optional. To retrieve information about tasks, role on which to match (that is, role that performed a task). When you use this role parameter, you must also specify the modelID parameter.
maxRows
String Optional. Maximum number of process instances to return, starting with those most recently logged. By default, the service gets all process instances.
isAnd
String Optional. Whether to use an AND or an OR condition for the criteria specified in the input parameters.
*true   Default. Use an AND condition. The service returns process instances that match all the criteria you specify.
*false Use an OR condition. The service returns process instances that match any of the criteria you specify.
sortColumn
String Optional. How to sort the returned list of process instances. By default, the service sorts the returned data using AUDITTIMESTAMP. This parameter works with the sortAscending parameter.
*PROCESSLABEL Model name.
*INSTANCEID Process instance ID.
*PARENTINSTANCEID Parent process instance ID, if any.
*STATUS Most recent status; the sort order is based on the numerical values associated with statuses. For a list of the status values, see Status Reference.
*AUDITTIMESTAMP The last time data was logged for the process instance.
sortAscending
String Optional. Whether to sort the returned list of process instances in ascending or descending order. The entries are sorted by the field identified by the sortColumn parameter.
*true    Default. Sort in ascending order.
*false  Sort in descending order.
criteriaFilter
String Optional. A filter that limits the returned instances based on pipeline values that are logged at run time. Define the pipeline variables to log when creating the process model and defining the step properties in Software AG Designer. For more information, see the Software AG Designer Online Help.
Use the following format to specify the filter: variable1=value1, value2, ... , valueN
For example, if a pipeline variable named city is logged and you want to return only those instances for which the value of the pipeline variable city is Paris, use the following filter: city=Paris
If you want to return instances for which city is Paris or Madrid, use the following filter: city=Paris, Madrid
To use multiple logged pipeline variables, specify and between the variables/values. For example, to return instances for which city is Paris and manager is Mercier, use the following filter: city=Paris and manager=Mercier
modelCriteriaFilter
String Optional. A filter that limits the returned instances based on filter fields and values that are associated with the process model on which the instance is based. Assign filter fields and values to process models using the service.
Use the following format to specify the filter: field1=value1, value2, ... , valueN
For example, if you have set a filter field named countryCode and want to return only those instances that use models for which countryCode is es, use the following filter: countryCode=es
If you want to return instances that use models for which the countryCode is es or fr, use the following filter: countryCode=es, fr
To use multiple filter fields, specify and between the fields/values. For example, to return instances of models for which the countryCode is es or fr and the department is AP, use the following filter: countryCode=es, fr and department=AP
isCustomIDExact
Boolean Optional. If is CustomIDExact is set to true, it matches the exact customID in the query; otherwise it uses the LIKE condition.
Output Parameters
The following table lists the output parameters.
instances
Document List List of process instances that match the specified criteria. For each process instance, the following fields are returned:
*ROOTCONTEXTID String Root context ID of the process instance.
*PARENTCONTEXTID String Parent context ID of the process instance.
*CONTEXTID String Context ID of the process instance.
*AUDITTIMESTAMP Number Time data was last logged for the process instance, in epoch time; that is, the number of seconds since January 1, 1970.
*AUDITTIMESTRING String Time data was last logged for the process instance in string format, YYYY-MM-DD hh:mm:ss.SSS zzz, where:
*YYYY-MM-DD is the date
*hh:mm:ss:SSS is the time, including milliseconds
*zzz is the time zone
*PARENTINSTANCEID String Instance ID of the process instance's parent instance, if any.
*PARENTINSTANCEITERATION Number Instance iteration of the process instance's parent instance, if any.
*INSTANCEID String Instance ID of the process instance.
*INSTANCEITERATION Number Instance iteration of the process instance.
*STATUS String Status of the process instance. The service returns the numerical value that represents the status. For a list of the status values, see Status Reference.
*STATUSDECODE String Status value for this process instance. The service returns the keyword value that represents the status. For the list of keyword values, for example, “Started” or “Completed,” see Status Reference.
*PROCESSKEY String Unique model ID of the process instance.
*PROCESSKEYDECODE String Process name of the process instance.
*CUSTOMID String The user-defined ID for the process instance that was assigned by executing the pub.prt.log:logCustomID service.
*PROCESSLABEL String Process name of the process instance.
message
String Optional. Error that occurred during the execution of this service if this service encountered an error.
Usage Notes
The following are services related to the modelCriteriaFilter input field:
*To assign a filter field that you can reference in modelCriteriaFilter, use the pub.monitor.process.model:setProcessFilter service.
*To retrieve a list of filter fields that are already set, use the pub.monitor.process.model:getProcessFilter service.
*To clear a filter field that you no longer need, use the pub.monitor.process.model:clearProcessFilter service.