Fixing flow problems

Sometimes a clinician accidentally submits a delivery summary form. Submitting the delivery summary form sets the user flow to Delivery Summary/Postnatal (id=4). there is not an automated way to "reset" a patient flow. Best way out of this situation is to do the following:

Delete the incorrect encounter, such as Delivery Summary.

Open up mysql.

Get the patient id:

select * from patient where district_patient_id = 'xxx'\G;

The get a list of the encounter id's

select id, form_id, created from encounter where patient_id=xxx order by id;

Get the patient status

select * from patient_status where id = xxx\G;

Then update the patient_status with the most recent legitamate encounter. In the following example, the patient is in antenatal flow (id=1):

update patient_status set current_flow=1, current_flow_encounter_id=xxx where id = xxx