Page History
...
- In the background the CRC will convert the request XML to a proper SQL Server contains statement (in this example below):
| Code Block | ||||
|---|---|---|---|---|
| ||||
with t as ( |
...
|
...
select f.patient_ |
...
num from dbo.observation_fact f |
...
where...
where f.concept_cd IN |
...
(...
( select concept_cd |
...
|
...
from dbo.concept_ |
...
dimension where concept_cd IN ('SO:0001483','SO:1000032') |
...
) ...
) AND (modifier_cd = '@' |
...
|
...
AND valtype_cd = 'B' |
...
AND CONTAINS(observation_blob,'rs377573539 AND T_to_C AND (Heterozygous OR Homozygous OR missing_zygosity)') |
...
) |
...
After the query is executed all patients matching the input genomic variants will be returned to the i2b2 web client.
