Live Queries

SELECT lts.extid as lextid,ltr.patient_id,ltr.id as request_id,ltr.location_id FROM "lab_test_request_details" inner join lab_test_requests as ltr on ltr.id = lab_test_request_details.lab_test_request_id
      inner join lab_test_specimens as lts on lts.lab_test_request_detail_id = lab_test_request_details.id
      inner join services as s on s.id = lab_test_request_details.service_id
      inner join specimens as sp on sp.id = lab_test_request_details.specimen_id WHERE (date(ltr.created_at) >= '2023-09-08' and s.dimm_code != '' and lab_test_request_details.specimen_recieved = 'Received' and ltr.location_id=12 and lab_test_request_details.status = 'Specimen Collected') GROUP BY lts.extid,ltr.patient_id,ltr.id,ltr.location_id  ORDER BY ltr.id desc

SELECT lts.extid as lextid,ltr.patient_id,ltr.id as request_id,ltr.location_id FROM "lab_test_request_details" inner join lab_test_requests as ltr on ltr.id = lab_test_request_details.lab_test_request_id
      inner join lab_test_specimens as lts on lts.lab_test_request_detail_id = lab_test_request_details.id
      inner join services as s on s.id = lab_test_request_details.service_id
      inner join specimens as sp on sp.id = lab_test_request_details.specimen_id WHERE (date(ltr.created_at) >= '2023-09-08' and s.dimm_code != '' and lab_test_request_details.specimen_recieved = 'Received' and ltr.location_id=12 and lab_test_request_details.status = 'Specimen Collected') GROUP BY lts.extid,ltr.patient_id,ltr.id,ltr.location_id  ORDER BY ltr.id desc

            SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull
              FROM pg_attribute a LEFT JOIN pg_attrdef d
                ON a.attrelid = d.adrelid AND a.attnum = d.adnum
             WHERE a.attrelid = '"menu_lists"'::regclass
               AND a.attnum > 0 AND NOT a.attisdropped
             ORDER BY a.attnum

SELECT     "bed_rate_categories".* FROM       "bed_rate_categories"  WHERE     (location_id = 33) ORDER BY  name