Survey Instance: survey_instance_action_queue

[jessica-woodland-scott-db]

Description

Need a way to queue survey actions from external jobs so that they go through the standard workflow steps for a survey, eg. when reopening, versioning correctly.

Proposal is to have a table to capture actions and then a scheduled job in Waltz to pick these up and implement them.

survey_instance_action_queue

Column	Type	Description	Example
id*	Long	Identifier for row	1
action*	Enum	Survey action to be implemented	SUBMITTING,REJECTING,REOPENING...
survey_instance_id*	Long	fk to survey instance table	1
action_params	String	Object to store additional parameters to pass to the command	{comment: "Reason for survey rejection"}
initial_state*	Enum	Status of the survey instance when the command was issued. Used for verifying the action can still be applied	APPROVED, COMPLETED...
submitted_at*	Timestamp	When was the action submitted
submitted_by*	String	Who submitted the action	ExampleJob / user_id
actioned_at	Timestamp	When was the action applied
status*	Enum	Indicates whether this action has been applied	PENDING / IN_PROGRESS / PRECONDITION_FAILURE / EXECUTION_FAILURE / SUCCESS
error_message	String	Indicates the reason why the job failed	"Initial state mismatch", error thrown during action
provenance	String	Which system / job added the task to the action list	waltz / ExampleJob

Resourcing

We intend to contribute this feature