Feature #167
Tag for GeneXpert Positive
Start date:
09/27/2012
Due date:
% Done:
0%
Component:
Description
Country is requesting a green tag that will be for all GeneXpert tested cases on which the result was positive for Resistance positive in Rifampicim
History
#1
Updated by Maurício Dos Santos over 12 years ago
- Status changed from New to Feedback
- Assignee set to Ricardo Memoria
Ricardo or Fernando,
What's a GeneXpert case? I think that we don't have that in SITETB...
#2
Updated by Maurício Dos Santos over 12 years ago
- Status changed from Feedback to In Progress
- Assignee changed from Ricardo Memoria to Maurício Dos Santos
As I don't have the access to Nigeria production environment, here it is the codition:
exists(select *
from tbcase c
inner join examdst edst on edst.case_id = c.id
inner join examdstresult edstr on edstr.exam_id = edst.id
inner join substance s on s.id = edstr.substance_id
where s.abbrevname1 like 'R'
and edstr.result = 1
and c.id = a.id);
#3
Updated by Maurício Dos Santos over 12 years ago
- Status changed from In Progress to Resolved
#4
Updated by Maurício Dos Santos over 12 years ago
Add the condition for the method GeneXpert