Feature #198
Etiqueta automática 5
Jorge Luiz da Rocha0%
Description
Título: Indicação de Amicacina
Quando:
- Caso com Teste de Sensibilidade com registro de resistência à Estreptomicina contendo Estreptomicina no esquema terapêutico;
- Caso com registro de uso de Estreptomicina em tratamentos anteriores para TB, com Estreptomicina no esquema terapêutico.
History
#1
Updated by Maurício Dos Santos over 12 years ago
Somente para casos em tratamento.
#2
Updated by Maurício Dos Santos over 12 years ago
- Tracker changed from Melhoria to Feature
- Status changed from New to Feedback
- Assignee changed from Maurício Dos Santos to Jorge Luiz da Rocha
Feito
(exists(select *
from tbcase c
inner join examdst dst on dst.case_id = c.id
inner join examdstresult dstr on dstr.exam_id = dst.id
inner join substance s on s.id = dstr.substance_id
inner join prescribedmedicine pm on pm.case_id = c.id
inner join medicine m on m.id = pm.medicine_id
where c.state in (1,2)
and s.abbrev_name1 like 'S'
and m.abbrevname like 'S'
and c.id = a.id)
or
exists(select *
from tbcase c
inner join prevtbtreatment p on p.case_id = c.id
inner join res_prevtbtreatment rp on rp.prevtbtreatment_id = p.id
inner join substance s on rp.substance_id = s.id
inner join prescribedmedicine pm on pm.case_id = c.id
inner join medicine m on m.id = pm.medicine_id
where c.state in (1,2)
and s.abbrev_name1 like 'S'
and m.abbrevname like 'S'
and c.id = a.id));
#3
Updated by Maurício Dos Santos over 12 years ago
Correção da primeira query
select *
from tbcase c
inner join examdst dst on dst.case_id = c.id
inner join examdstresult dstr on dstr.exam_id = dst.id
inner join substance s on s.id = dstr.substance_id
inner join prescribedmedicine pm on pm.case_id = c.id
inner join medicine m on m.id = pm.medicine_id
where c.state in (1,2)
and s.abbrev_name1 like 'S'
and m.abbrevname like 'S'
and dstr.result = 1
#4
Updated by Maurício Dos Santos over 12 years ago
- Status changed from Feedback to Closed
#5
Updated by Maurício Dos Santos over 12 years ago
- Status changed from Closed to In Progress
Alteraçao solicitada:
Considerar somente o teste de sensibilidade do diagnostico.
#6
Updated by Maurício Dos Santos about 12 years ago
Select *
from tbcase a
where
a.state in (1,2)
and a.classification in (1)
and (exists(select *
from prescribedmedicine pm
inner join examdst dst on dst.case_id = pm.case_id
inner join examdstresult dstr on dstr.exam_id = dst.id
inner join substance s on s.id = dstr.substance_id
inner join medicine m on m.id = pm.medicine_id
where pm.case_id = a.id
and dst.dateCollected = (select min(dateCollected) from examdst d where d.case_id = a.id)
and s.abbrev_name1 like 'S'
and m.abbrevname like 'S'
and dstr.result = 1)
or
exists(select *
from prescribedmedicine pm
inner join prevtbtreatment p on p.case_id = pm.case_id
inner join res_prevtbtreatment rp on rp.prevtbtreatment_id = p.id
inner join substance s on rp.substance_id = s.id
inner join medicine m on m.id = pm.medicine_id
where p.case_id = a.id
and s.abbrev_name1 like 'S'
and m.abbrevname like 'S'));
#7
Updated by Maurício Dos Santos about 12 years ago
- Status changed from In Progress to Closed