FINDCASES
Usage
TIBCO iProcess Workspace (Browser)
TIBCO iProcess Workspace (Windows)
Filter cases and return the count of cases based on the applied filter.
Syntax
FINDCASES (procname, filter, arrayname, sort)
where:
• | procname (text) is the procedure name. |
• | filter is a text string specifying the filter criteria to be applied on the cases. |
For more information about filter criteria, see the "Filtering Work Items and Cases" topic in TIBCO iProcess Server Objects (Java) Programmer’s Guide.
• | arrayname (text) is the name of the array (numeric) field where the filtered case numbers are stored. |
• | sort is a text string specifying the sorting order. |
For more information about sorting criteria, see the “Sorting Work Items and Cases” topic in TIBCO iProcess Server Objects (Java) Programmer’s Guide.
Returns
A numeric value containing the count of cases based on filter or one of the following numeric values:
Value |
Description |
---|---|
0 | No cases are found |
-1 |
Error in parameter |
-2 |
Error in format |
-3 |
System error |
-4 |
Any other error. Check logs for further info. |
Example
This example returns the count in TOTCASE and populates the CASELIST array with case numbers filtered on "ACCTYPE=‘PERSONAL’ AND REGION='EUROPE'” and sorted on “SW_CASEDESC,-SW_CASENUM/R”.
TOTCASE:=FINDCASES(“CARPOOL”, “ACCTYPE=‘PERSONAL’ AND REGION='EUROPE'”, "CASELIST", “SW_CASEDESC,-SW_CASENUM/R”);
GETCASE
Usage
TIBCO iProcess Workspace (Browser)
TIBCO iProcess Workspace (Windows)
Return a text string value of the field for a given procedure, case number, and field name.
Syntax
GETCASE (procname, casenum, fieldname)
where:
• | procname (text) is the procedure name. |
• | casenum (numeric) is the case number. |
• | fieldname (text) is the name of a case field for which detail is required. Can be system or custom case fields. |
Returns
A text string that matches the value of the field specified in fieldname for the given casenum.
Returns SW_NA
in case of error or undefined field.
Example
This example returns the type of the vehicle in VTYPE, of the first case that matches the criteria "ACCTYPE=‘PERSONAL’ AND REGION='EUROPE'” and sorted on “SW_CASEDESC,-SW_CASENUM/R”.
TOTCASE:=FINDCASES(“CARPOOL”, “ACCTYPE=‘PERSONAL’ AND REGION='EUROPE'”, "CASELIST", “SW_CASEDESC,-SW_CASENUM/R”); VTYPE:=GETCASE(“CARPOOL”, CASELIST[0], “VEHICLE_TYPE”);