Ask
Questions are answered from the same definitions the operator uses. When a word has two meanings in the group, both answers come back, each with its owner, version and SQL.
How many no-shows last week?How many active patients do we have?Late cancellations todayAbnormal results this week
18 results according to the Lab manager (lab v1, this week (from Monday)).
Lab meaning
18
18 results
Lab manager (lab) · lab v1 · this week (from Monday)
Flag abnormal or critical, resulted in the period.
SELECT r.id AS result_id, r.test_code, r.flag, r.clinic_id, r.resulted_at
FROM results r
WHERE r.flag IN ('abnormal', 'critical') AND r.resulted_at >= TIMESTAMP '2026-11-16 00:00:00' AND r.resulted_at < TIMESTAMP '2026-11-16 13:00:00'
AND r.resulted_at <= TIMESTAMP '2026-11-16 13:00:00'