Feature #168
Medical consultation -
Start date:
09/27/2012
Due date:
% Done:
0%
Component:
Description
Country is requesting a Red tag for any medical consultation before 2009
Country is requesting a Red tag for any medical consultation without the patients weight
History
#1
Updated by Maurício Dos Santos over 12 years ago
- Status changed from New to Closed
- Assignee set to Maurício Dos Santos
Fernando here it is the conditions:
Country is requesting a Red tag for any medical consultation before 2009
exists(select *
from tbcase c
inner join medicalexamination m on m.case_id = c.id
where (m.weight is null or m.weight = '') and c.id = a.id)
Country is requesting a Red tag for any medical consultation without the patients weight
exists(select *
from tbcase c
inner join medicalexamination m on m.case_id = c.id
where m.event_date < '2009-01-01' and c.id = a.id)
#2
Updated by Maurício Dos Santos over 12 years ago
- Status changed from Closed to In Progress
#3
Updated by Maurício Dos Santos over 12 years ago
- Status changed from In Progress to Resolved