User Tools

Site Tools


SET CASE STATUS

Guide Section: Excel Desktop Client | EASAP Tree: EVENT PROCESSINGACTION


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

Page Tools