Guide Section: Excel Desktop Client | EASAP Tree: EVENT PROCESSING → ACTION

SET CASE STATUS is part of the Excel Client functionality.

SET CASE STATUS modifies the status field of a 'case' in the cases database table.

• A case in an Excel Client EASAP has the lifecycle below,
  • EXCEL TO EXCEL DESKTOP→Action: New
    • → Creates an empty case with status→NEW
  • EASA→Save from within an Excel Client writes the case to a database and sets status→IN_PROGRESS
  • status→FINISHED shows completion of some external validation step from any MySQL enabled client
  • status→DELETED removes a case from active use in a non-destructive way
    • → Actual destruction of a case record is not supported because of the possibility of a later audit

SET CASE STATUS
Essential Parameters:
Status:	Choose from NEW, IN_PROGRESS, FINISHED or DELETED
Case Id:	Percent delimited reference to a CASE VIEWER or a SCALAR reference to a case_id in the database.
Optional Parameters:
Delimiter:	Character to delimit a SCALAR reference in Case Id: (default→%)
Do if:	Logical expression, if false then action NOT performed else default→true