Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Appendix B SSOLite Stored Procedures : Data Procedures : SW_MODIFY_CASEDATA

SW_MODIFY_CASEDATA
The SW_MODIFY_CASEDATA procedure allows you to modify the data of an existing case. Use an SW_ADD_PACK_DATA procedure to specify the data to be modified. Then, an immediately following SW_MODIFY_CASEDATA posts an instruction to the BG process to carry out the change. You can use the SW_MODIFY_CASEDATA procedure to set case data for main procedures and sub-procedures.
This event is audited, using audit message 058. See TIBCO iProcess Engine Administrator’s Guide for details of audit messages.
Syntax
SW_MODIFY_CASEDATA (
proc_name varchar(8),
proc_maj_ver integer,
proc_min_ver integer,
case_number numeric(20),
reason varchar(24),
user_id varchar(24))
where:
proc_name is the name of the procedure that you want to modify 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_number is the case number of the main procedure for which the data is to be modified.
reason is a reason for the case data modification, used in the audit trail.
user_id is the name of the iProcess user who is performing the modification.
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 modifies data for case 876 of the Transfer procedure. The SW_ADD_PACK_DATA statement changes the value of the TEXT1 field to "New customer name". The SW_MODIFY_CASEDATA call then identifies the procedure and case to be changed, and provides the "Modified For Graft" message which will be displayed in the audit trail.

 
CALL swpro.SW_ADD_PACK_DATA('TEXT1', 'New customer name')/
CALL swpro.SW_MODIFY_CASEDATA('Transfer', -1, -1, 876, 'Modified For Graft', 'swadmin')/

 

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.