Ward Round Sheet search function gives error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Hospital Handover Database |
New
|
Undecided
|
Unassigned |
Bug Description
From Ward Round Sheet, using the Advanced Search does not work. Irrespective of text entry in Search box, it errors as follows:
PHP error happened
Technical information
Error type 256
Error description Unknown column 'consultants.
URL 192.168.
Error file /var/www/
Error line 26
SQL query select `Primary`, `Patient Name`, `Date of Birth`, `Unit Number`, `Sex`, `Ward`, `Bed`, `Consultant`, `Code`, `Category`, `Admission Date`, `Diagnosis`, `Allergies`, `Notes`, `Nurses`, `Social Services`, `Team`, `Ward Round Notes` From `patients` WHERE (`Category` = "Inpatient") and (1=1 and upper(`
The column entry should be `Consultant` rather than `consultants.