Queries of Report editor

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
 
<p>To open the Report editor, go to Report -&gt; Report editor in the menu bar.</p>
 
<p>To open the Report editor, go to Report -&gt; Report editor in the menu bar.</p>
−
<p>For better understanding, we divide the window into "1. Report editor: selection" and "2. Report editor: queries".</p>
+
<p>For better understanding, we divide the window into "1. Selection" and "2. Queries".</p>
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 8: Line 8:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<h3>1. Tabels and fields</h3>
+
<h3>1. Selection - Tabels and fields</h3>
 
<table border="0">
 
<table border="0">
 
<tbody>
 
<tbody>
Line 14: Line 14:
 
<td><img src="/images/Tables1RE.png" alt="" width="327" height="473" /></td>
 
<td><img src="/images/Tables1RE.png" alt="" width="327" height="473" /></td>
 
<td>
 
<td>
−
<p>On the left, all the tables and fields are placed which you can use for your query.</p>
+
<p>On the left, all the tables and fields are placed which you can use for your query:</p>
 
<ul>
 
<ul>
 
<li>Patients</li>
 
<li>Patients</li>
Line 24: Line 24:
 
<li>Referrers</li>
 
<li>Referrers</li>
 
</ul>
 
</ul>
−
<p>&nbsp;</p>
+
<p><span class="short_text" lang="en"><span class="hps">Pull subgroups from the left in the middle pane to build a query.</span></span></p>
−
<p><span class="short_text" lang="en"><span class="hps">To define conditions on a certain field, double click it's label. </span></span></p>
+
<p><span class="short_text" lang="en"><span class="hps">&nbsp;</span></span></p>
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<p><span class="short_text" lang="en"><span class="hps">Pull subgroups from the left in the middle pane to build a query.</span></span></p>
+
<p><span class="short_text" lang="en"><span class="hps">&nbsp;</span></span></p>
−
<p><span class="short_text" lang="en"><span class="hps"><br /></span></span></p>
+
<h3><span class="short_text" lang="en"><span class="hps">2. Queries - Create and modify queries</span></span></h3>
 +
<h3>Menu bar</h3>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" /></td>
 +
<td>&nbsp;</td>
 +
</tr>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" /></td>
 +
<td>&nbsp;</td>
 +
</tr>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/OpenRE.png" alt="" width="92" height="37" /></td>
 +
<td>&nbsp;</td>
 +
</tr>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SaveRE.png" alt="" width="89" height="83" /></td>
 +
<td>&nbsp;</td>
 +
</tr>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ResultRE.png" alt="" width="208" height="91" /></td>
 +
<td>&nbsp;</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td><img src="/images/Person1RE.png" alt="" width="400" /></td>
 +
<td>
 
<p><span class="short_text" lang="en"><span class="hps">In the right pane the fields will appear for each chosen group:</span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps">In the right pane the fields will appear for each chosen group:</span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps">there you can select which fields should appear in the result.</span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps">there you can select which fields should appear in the result.</span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps"><br /></span></span></p>
 
<p><span class="short_text" lang="en"><span class="hps"><br /></span></span></p>
 +
</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Street.png" alt="" width="146" height="53" /></td>
 +
</tr>
 +
<tr>
 +
<td>
 +
<p><span class="short_text" lang="en"><span class="hps">To define conditions on a certain field, double click it's label. </span></span></p>
 +
</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>

Revision as of 18:13, 26 November 2012

To open the Report editor, go to Report -> Report editor in the menu bar.

For better understanding, we divide the window into "1. Selection" and "2. Queries".

<tbody> </tbody>
REWindow.png

1. Selection - Tabels and fields

<tbody> </tbody>
<img src="/images/Tables1RE.png" alt="" width="327" height="473" />

On the left, all the tables and fields are placed which you can use for your query:

  • Patients
  • Cycles
  • Examinations / Medical histories
  • Cryo
  • Administration
  • Personell
  • Referrers

Pull subgroups from the left in the middle pane to build a query.

 

 

2. Queries - Create and modify queries

Menu bar

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/OpenRE.png" alt="" width="92" height="37" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SaveRE.png" alt="" width="89" height="83" />  
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ResultRE.png" alt="" width="208" height="91" />  

 

<tbody> </tbody>
<img src="/images/Person1RE.png" alt="" width="400" />

In the right pane the fields will appear for each chosen group:

there you can select which fields should appear in the result.

 

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Street.png" alt="" width="146" height="53" />

To define conditions on a certain field, double click it's label.