Feature #170
Red tag
Start date:
09/27/2012
Due date:
% Done:
0%
Component:
Description
Country request = red tag for all cases sensitive for R, H, E and S.
History
#1
Updated by Maurício Dos Santos over 12 years ago
- Status changed from New to Feedback
- Assignee set to Luiz Fernando Avelino
Fernando,
Devo considerar todos os exames de sensibilidade ou somente o ultimo?
Devo considerar todos os casos ou somente os que estao em tratamento?
#2
Updated by Maurício Dos Santos over 12 years ago
- Assignee changed from Luiz Fernando Avelino to Maurício Dos Santos
consider only the last dst exam and all cases (instead of it casestate)
#3
Updated by Maurício Dos Santos over 12 years ago
- Status changed from Feedback to Resolved
Done, above is the condition:
exists(select *
from tbcase c
inner join examdst edst on c.id = edst.case_id
inner join examdstresult eresult on eresult.exam_id = edst.id
inner join substance s on s.id = eresult.substance_id
where edst.datecollected = (select max(datecollected) from examdst where case_id = c.id)
and (s.abbrev_Name1 like 'R' or s.abbrev_Name1 like 'H' or s.abbrev_Name1 like 'E' or s.abbrev_Name1 like 'S')
and c.id = a.id);