Message-ID: <2007054466.7908.1711649613932.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7907_813678543.1711649613930" ------=_Part_7907_813678543.1711649613930 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Update CRC Properties File (Deprecated from 1.7.12 version)</tit= le> <!--[if gte mso 9]> <xml> <o:OfficeDocumentSettings> <o:TargetScreenSize>1024x640</o:TargetScreenSize> <o:PixelsPerInch>72</o:PixelsPerInch> <o:AllowPNG/> </o:OfficeDocumentSettings> <w:WordDocument> <w:View>Print</w:View> <w:Zoom>90</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml> <![endif]--> <style> <!-- @page Section1 { size: 8.5in 11.0in; margin: 1.0in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; } table { border: solid 1px; border-collapse: collapse; } table td, table th { border: solid 1px; padding: 5px; } td { page-break-inside: avoid; } tr { page-break-after: avoid; } div.Section1 { page: Section1; } /* Confluence print stylesheet. Common to all themes for print medi= a */ /* Full of !important until we improve batching for print CSS */ @media print { #main { padding-bottom: 1em !important; /* The default padding of 6em is to= o much for printouts */ } body { font-family: Arial, Helvetica, FreeSans, sans-serif; font-size: 10pt; line-height: 1.2; } body, #full-height-container, #main, #page, #content, .has-personal-sid= ebar #content { background: #fff !important; color: #000 !important; border: 0 !important; width: 100% !important; height: auto !important; min-height: auto !important; margin: 0 !important; padding: 0 !important; display: block !important; } a, a:link, a:visited, a:focus, a:hover, a:active { color: #000; } #content h1, #content h2, #content h3, #content h4, #content h5, #content h6 { font-family: Arial, Helvetica, FreeSans, sans-serif; page-break-after: avoid; } pre { font-family: Monaco, "Courier New", monospace; } #header, .aui-header-inner, #navigation, #sidebar, .sidebar, #personal-info-sidebar, .ia-fixed-sidebar, .page-actions, .navmenu, .ajs-menu-bar, .noprint, .inline-control-link, .inline-control-link a, a.show-labels-editor, .global-comment-actions, .comment-actions, .quick-comment-container, #addcomment { display: none !important; } /* CONF-28544 cannot print multiple pages in IE */ #splitter-content { position: relative !important; } .comment .date::before { content: none !important; /* remove middot for print view */ } h1.pagetitle img { height: auto; width: auto; } .print-only { display: block; } #footer { position: relative !important; /* CONF-17506 Place the footer at en= d of the content */ margin: 0; padding: 0; background: none; clear: both; } #poweredby { border-top: none; background: none; } #poweredby li.print-only { display: list-item; font-style: italic; } #poweredby li.noprint { display: none; } /* no width controls in print */ .wiki-content .table-wrap, .wiki-content p, .panel .codeContent, .panel .codeContent pre, .image-wrap { overflow: visible !important; } /* TODO - should this work? */ #children-section, #comments-section .comment, #comments-section .comment .comment-body, #comments-section .comment .comment-content, #comments-section .comment p { page-break-inside: avoid; } #page-children a { text-decoration: none; } /** hide twixies the specificity here is a hack because print styles are getting loaded before the base styles. */ #comments-section.pageSection .section-header, #comments-section.pageSection .section-title, #children-section.pageSection .section-header, #children-section.pageSection .section-title, .children-show-hide { padding-left: 0; margin-left: 0; } .children-show-hide.icon { display: none; } /* personal sidebar */ .has-personal-sidebar #content { margin-right: 0px; } .has-personal-sidebar #content .pageSection { margin-right: 0px; } .no-print, .no-print * { display: none !important; } } --> </style> </head> <body> <h1>Update CRC Properties File (Deprecated from 1.7.12 version)</h1> <div class=3D"Section1"> <div class=3D"contentLayout2">=20 <div class=3D"columnLayout single" data-layout=3D"single">=20 <div class=3D"cell normal" data-type=3D"normal">=20 <div class=3D"innerCell">=20 <h1 id=3D"UpdateCRCPropertiesFile(Deprecatedfrom1.7.12version)-CRCPropertie= sConfiguration">CRC Properties Configuration</h1> <div class=3D"confluence-information-macro confluence-information-macro-inf= ormation"> <p class=3D"title">1.7.12</p> <span class=3D"aui-icon aui-icon-small aui-iconfont-info confluence-informa= tion-macro-icon"></span> <div class=3D"confluence-information-macro-body"> <p>Beginning in 1.7.12, the CRC properties are in the database! See <a href= =3D"https://harvard.zoom.us/j/96691149582?pwd=3DRTVGQmpoNmtVelY5VCttZFdKMHd= MQT09" class=3D"external-link" rel=3D"nofollow">this link</a>.</p> </div> </div> <p><br></p> <p>Prio to 1.7.17 versions,  multifact table property  is A new p= roperty, the <strong>queryprocessor.multifacttable</strong><span> = ;property,</span> has been added to the <strong>crc.properties</strong> fil= e. When this property is set to true the CRC will now look for multiple fac= t tables. By default, this property is set to false. If you are going to be= using multiple fact tables you will need to update this property to be tru= e.</p> <p><br></p> <p style=3D"margin-left: 60.0px;"><span style=3D"color: rgb(0,0,0);"><stron= g>Property:</strong> queryprocessor.multifacttable</span></p> <div> <p><br></p> <div class=3D"table-wrap"> <table class=3D"wrapped confluenceTable"> <colgroup> <col> <col> </colgroup> <tbody> <tr> <th class=3D"confluenceTh">Value</th> <th class=3D"confluenceTh">Behavior</th> </tr> <tr> <td class=3D"confluenceTd"><strong>false</strong></td> <td class=3D"confluenceTd">The CRC will continue to work as it does in the = classic i2b2. Only one fact table (observation_fact) will be queried ("sing= le" mode)</td> </tr> <tr> <td colspan=3D"1" class=3D"confluenceTd"><strong>true</strong></td> <td colspan=3D"1" class=3D"confluenceTd">The CRC will work in both modes; s= ingle or multiple fact tables.</td> </tr> </tbody> </table> </div> </div> </div>=20 </div>=20 </div>=20 <div class=3D"columnLayout single" data-layout=3D"single">=20 <div class=3D"cell normal" data-type=3D"normal">=20 <div class=3D"innerCell">=20 <p><br></p> </div>=20 </div>=20 </div>=20 <div class=3D"columnLayout single" data-layout=3D"single">=20 <div class=3D"cell normal" data-type=3D"normal">=20 <div class=3D"innerCell">=20 <h2 id=3D"UpdateCRCPropertiesFile(Deprecatedfrom1.7.12version)-Updatecrc.pr= opertiesfile">Update crc.properties file</h2> <p style=3D"margin-left: 30.0px;">1. Open the <strong>crc.properties</= strong> file and scroll to the section called <strong><span style=3D"c= olor: rgb(0,0,0);">Derived/Multi fact table parameter</span></strong><span = style=3D"color: rgb(0,0,0);">.</span></p> <p style=3D"margin-left: 30.0px;"><span style=3D"color: rgb(0,0,0);">2.&nbs= p;<span>Edit the </span><em>queryprocessor.multifacttable</em><span> proper= ty to tell the CRC to query multiple fact tables.</span></span></p> <div class=3D"panel" style=3D"background-color: #ffffff;border-color: #ccc;= border-style: solid;border-width: 1px;"> <div class=3D"panelHeader" style=3D"border-bottom-width: 1px;border-bottom-= style: solid;border-bottom-color: #ccc;background-color: #E5DFEC;"> <b>Multi-fact table parameter</b> </div> <div class=3D"panelContent" style=3D"background-color: #ffffff;">=20 <p style=3D"margin-left: 30.0px;"><span style=3D"color: rgb(63,127,95);"># = Derived/Multi fact table parameter</span></p> <p style=3D"margin-left: 30.0px;"><span style=3D"color: rgb(63,127,95);">&n= bsp;</span><span style=3D"color: rgb(0,0,0);">queryprocessor.multifacttable= =3D</span><span style=3D"color: rgb(42,0,255);">true</span></p>=20 </div> </div> <p style=3D"margin-left: 30.0px;"><span style=3D"color: rgb(0,0,0);"> = </span></p> <p style=3D"margin-left: 30.0px;">3. Save your changes and close the file. = </p> <p></p> <div class=3D"i2b2-panel">=20 <div class=3D"table-wrap"> <table class=3D"i2b2-note confluenceTable">=20 <colgroup>=20 <col width=3D"24">=20 <col>=20 </colgroup>=20 <tbody>=20 <tr>=20 <td class=3D"confluenceTd"> <img src=3D"https://community.i2b2.org/wiki/dow= nload/attachments/14091764/icon_note.png" width=3D"16" height=3D"16" align= =3D"absmiddle" alt=3D"info" border=3D"0"> </td>=20 <td class=3D"confluenceTd"> <b>Note</b> <br><br>If the above parameter does= not exist in the crc.properties file, then you have to add it so the CRC c= an query more than one fact table. </td>=20 </tr>=20 </tbody>=20 </table> </div>=20 </div> <p></p> <p></p> </div>=20 </div>=20 </div>=20 </div> </div> </body> </html> ------=_Part_7907_813678543.1711649613930--