Details
-
New Feature
-
Status: Closed
-
Major
-
Resolution: Completed
-
None
-
None
-
None
-
Query Tool, Timeline View
-
Queries, Temporal Queries
Description
An enhancement to CRC to run queries against derived fact tables (Multi-fact tables) as found in OMOP or PCORI.
Enabled by a crc.properties parameter
# Derived fact table parameter
queryprocessor.derivedfacttable=true
If parameter does not exist, then queries run against obs_fact table.
On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain.
In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query
Enabled by a crc.properties parameter
# Derived fact table parameter
queryprocessor.derivedfacttable=true
If parameter does not exist, then queries run against obs_fact table.
On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain.
In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Lori Phillips [ lcp5 ] |
| Status | New [ 10000 ] | Open [ 1 ] |
| Assignee | Lori Phillips [ lcp5 ] | Janice Donahoe [ jmd86 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Ready to Test [ 10001 ] |
| Fix Version/s | 1.7.09 [ 10306 ] |
| Description |
An enhancement to CRC to run queries against derived fact tables as found in OMOP or PCORI.
Enabled by a crc.properties parameter # Derived fact table parameter queryprocessor.derivedfacttable=true If parameter does not exist, then queries run against obs_fact table. |
An enhancement to CRC to run queries against derived fact tables as found in OMOP or PCORI.
Enabled by a crc.properties parameter # Derived fact table parameter queryprocessor.derivedfacttable=true If parameter does not exist, then queries run against obs_fact table. On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain. In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query |
| Status | Ready to Test [ 10001 ] | Testing [ 10002 ] |
| Testing Notes |
Currently testing the install scripts.
Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables. |
|
| Status | Testing [ 10002 ] | Testing [ 10002 ] |
| Testing Notes |
Currently testing the install scripts.
Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables. |
Currently testing the install scripts.
Next step will be to test running queries using the OMOP demo data inserted into the i2b2 tables. Tested and queries appear to be working correctly. |
| Status | Testing [ 10002 ] | Testing [ 10002 ] |
This new feature will be included in release 1.7.09
| Resolution | Completed [ 10000 ] | |
| Status | Testing [ 10002 ] | Resolved [ 5 ] |
| Summary | Run queries using derived fact tables (OMOP) | Run queries using derived fact tables (Multi-fact table & OMOP) |
| Description |
An enhancement to CRC to run queries against derived fact tables as found in OMOP or PCORI.
Enabled by a crc.properties parameter # Derived fact table parameter queryprocessor.derivedfacttable=true If parameter does not exist, then queries run against obs_fact table. On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain. In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query |
An enhancement to CRC to run queries against derived fact tables (Multi-fact tables) as found in OMOP or PCORI.
Enabled by a crc.properties parameter # Derived fact table parameter queryprocessor.derivedfacttable=true If parameter does not exist, then queries run against obs_fact table. On 1/4/17 added capability to query more than one domain for the case of a concept folder whose children span more than one domain (eg labs with measurement and observation) Each concept is assigned to one domain but a folder may have children within a separate domain. In the case for no filter list, OMOP returns an empty observation set by default. The reason for this is there since there are no concepts in the filter list, we dont know which domain table to query |
| Status | Resolved [ 5 ] | Closed [ 6 ] |