SW_CLOSE

Copyright © Cloud Software Group, Inc. All Rights Reserved

Appendix B SSOLite Stored Procedures : Command Procedures : SW_CLOSE

SW_CLOSE

The SW_CLOSE procedure closes an active case of a procedure.

If an event is set for the OnBeforeClose event, the event will be triggered when the case is about to close but before the case is actually closed. If an event is set for the OnAfterClose event, the event will be triggered after closing the case.

Syntax

SW_CLOSE (
proc_name varchar(8),
proc_maj_ver integer,
proc_min_ver integer,
case_number numeric(20),
user_id varchar(24))

where:

•

proc_name is the name of the procedure that you want to close a case of.

•

proc_maj_ver is either the major version number of the proc_name procedure, or -1. See the notes below.

•

proc_min_ver is either the minor version number of the proc_name procedure, or -1. See the notes below.

•

case_num is the number of the case that is to be closed.

•

user_id is the name of the iProcess user who is closing the case.

Notes

Instead of using the specific major and/or minor version number of the procedure, you can specify both the proc_maj_ver and proc_min_ver parameters as -1. If you do this, iProcess will use the version number of the procedure that the case was originally started with or, that it has subsequently been migrated to (if a subsequent version has been released while the case is still in progress).

If you specify one version number parameter as -1, you must specify the other one as -1 as well.

Example

This example closes the 103 case of the CUSTREQ procedure.

CALL owner.SW_CLOSE ('CUSTREQ', -1, -1, 103, 'user35')/