Multi-fact Table
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

CRC Properties Configuration

In order for the CRC to know there are multiple fact tables
Info
title1.7.12

Beginning in 1.7.12, the CRC properties are in the database! See this link.


Prio to 1.7.17 versions,  multifact table property  is A new property, the queryprocessor.multifacttable property in the , has been added to the crc.properties file needs to be updated file. When this property is set to true the CRC will now look for multiple fact tables. By default, this property is set to false, however for the i2b2 on OMOP project this needs to be set to . If you are going to be using multiple fact tables you will need to update this property to be true.


Property: queryprocessor.multifacttable


 

ValueBehavior
falseThe CRC will continue to work as it does in the classic i2b2. Only one fact table (observation_fact) will be queried ("single" mode)
trueThe CRC will work in both modes; single or multiple fact tables.



Update crc.properties file

1. Open the crc.properties file and scroll to the section called Derived/Multi fact table parameter.

2. Edit the queryprocessor.multifacttable property to tell the CRC to query multiple fact tables.

 

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#E5DFEC
borderStylesolid
titleMulti-fact table parameter

# Derived/Multi fact table parameter

 queryprocessor.multifacttable=true

 

3. Save your changes and close the file.

 
html-text
<div class="i2b2-panel">
    <table class="i2b2-note">
        <colgroup>
            <col width="24">
            <col>
        </colgroup>
        <tbody>
            <tr>
                <td>
                    <img src="https://community.i2b2.org/wiki/download/attachments/14091764/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
                </td>
                <td>
                    <b>Note</b>
                    <br><br>If the above parameter does not exist in the crc.properties file, then you 
will
have 
need
to add it 
in
so 
order for
the CRC 
to
can 
be
query 
able
more 
to
than 
query
one 
multiple
fact 
tables
table.
                </td>
            </tr>
        </tbody>
    </table>
</div>