User Tools

Site Tools


SET CASE STATUS

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:

  • DATABASE TO EXCEL DESKTOP > Action: New
    …Creates an empty case with: status > NEW
  • 'EASA Ribbon > 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: Select from NEW, IN_PROGRESS, FINISHED or DELETED
Case Id:Enter a percent delimited reference to a CASE VIEWER or other SCALAR reference holding a case_ID in the database.
Optional Parameters:
Delimiter:Set a character to delimit a SCALAR reference in Case Id:
Default: %
Do if:Enter a logical expression, if true then action performed and not otherwise
Default: true