is there any module that can manage Bed in hospital instead of adding script simple UI

hi @binduak

sorry to bothering you !! i have try to follow wiki unfortunately no luck i got an error while executing syntax!! could you please guide me little bit :slight_smile: appreciate your help !!

mysql> SET @parent_location_id = (select location_id from location where name='Emergency Ward');
Query OK, 0 rows affected (0.00 sec)

mysql> SET @location_id = (select location_id from location where name='Emergency General Ward');
Query OK, 0 rows affected (0.00 sec)

mysql> SET @location_tag_id = (select location_tag_id from location_tag where name='Admission Location');
Query OK, 0 rows affected (0.00 sec)

mysql> insert into location (name, description, creator, retired, date_created, uuid) values('General Ward', 'Emergency Ward', 1, 0, NOW(), UUID());
Query OK, 1 row affected (0.11 sec)

mysql>
mysql> insert into location (name, description, creator, retired, date_created, uuid, parent_location) values('Physical General Ward', '2ND Floor of General Ward', 1, 0, NOW(), UUID(), @parent_location_id);
Query OK, 1 row affected (0.07 sec)

mysql> insert into location_tag_map values( @parent_location_id , @location_tag_id);
ERROR 1048 (23000): Column 'location_id' cannot be null
mysql>

with best Regard. Bhandari