Example 6

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
 
(12 intermediate revisions by one user not shown)
Line 1: Line 1:
 +
<p>To open&nbsp;<strong>Report editor</strong>, go to&nbsp;<strong>Reports -&gt; Report editor&nbsp;</strong>in the menu bar.</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0" width="10" height="24">
 +
<tbody>
 +
<tr>
 +
<td><img src="/images/ReportEd.png" alt="" /><br /></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 +
<p>&nbsp;</p>
 
<p>After opening the <strong>Report Editor</strong>, you will see on the main screen the <strong>Report editor selection</strong> with tables and fields, in addition to the <strong>Report editor queries</strong> which allows you to create and edit queries.</p>
 
<p>After opening the <strong>Report Editor</strong>, you will see on the main screen the <strong>Report editor selection</strong> with tables and fields, in addition to the <strong>Report editor queries</strong> which allows you to create and edit queries.</p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
Line 22: Line 32:
 
<td>
 
<td>
 
<p>[[Image:CycleOfWomanTable.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/CycleOfWomanTable.png| ]]</p>
 
<p>[[Image:CycleOfWomanTable.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/CycleOfWomanTable.png| ]]</p>
 +
<p>&nbsp;</p>
 
<p>[[Image:CycleOfWomanDesiredFields.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/CycleOfWomanDesiredFields.png|    ]]</p>
 
<p>[[Image:CycleOfWomanDesiredFields.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/CycleOfWomanDesiredFields.png|    ]]</p>
 
</td>
 
</td>
Line 39: Line 50:
 
</tr>
 
</tr>
 
<tr>
 
<tr>
−
<td>&nbsp;</td>
+
<td>
 +
<p>You can move as many tables as you want and choose the right fields to create some more complex queries that match your requierments.</p>
 +
<p>It's important to know that with every table you move, recalculations are made in the report editor selection to display just tables and fields that can be joined with the current table you have chosen and go with.</p>
 +
<p>The tables and filters choice should be carefully considered, so you will be able to reach the specific requested fields.</p>
 +
</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
Line 52: Line 67:
 
</tr>
 
</tr>
 
<tr>
 
<tr>
−
<td colspan="2">[[Image:CycleOfWomanQueryResult.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/CycleOfWomanQueryResult.png|      ]]</td>
+
<td colspan="2">
 +
<p>[[Image:Example6Result1.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/Example6Result1.png|      ]]</p>
 +
<p>&nbsp;</p>
 +
<p>[[Image:Example6Result2.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/Example6Result2.png|      ]]</p>
 +
<p>&nbsp;</p>
 +
<p>[[Image:Example6Result3.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/Example6Result3.png|      ]]</p>
 +
<p>&nbsp;</p>
 +
<p>[[Image:Example6Result4.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/Example6Result4.png|      ]]</p>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td style="text-align: center;" colspan="2">The query result you get, contains as many columns as the fields you have previously chosen.</td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
Line 73: Line 99:
 
<p><span lang="en">This filter can be further processed.</span></p>
 
<p><span lang="en">This filter can be further processed.</span></p>
 
</span></td>
 
</span></td>
 +
</tr>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Example6CustomFilter1.png" alt="" />
 +
<p>&nbsp;</p>
 +
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Example6CustomFilter2.png" alt="" /></td>
 +
<td><span lang="en"><span lang="en">You can also customize and set filters of your choice.</span></span></td>
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
Line 116: Line 148:
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<h3>More</h3>
 
<h3>More</h3>
−
<table style="margin-left: auto; margin-right: auto;" border="0">
 
−
<tbody>
 
−
<tr>
 
−
<td>[[Image:CycleOfWomanOocyteRetrieval.png|none|740px|thumb|left|link=http://wiki.meditex-software.com/images/CycleOfWomanOocyteRetrieval.png|      ]]</td>
 
−
</tr>
 
−
<tr>
 
−
<td><span id="result_box" lang="en">If <span id="result_box" lang="en"><span title="Sind im Bereich &bdquo;Therapie der Frau&ldquo; nicht alle gew&uuml;nschten Felder zu finden, dann ist es nat&uuml;rlich m&ouml;glich weitere Details in die Abfrage zu nehmen.  ">you can not find all the required fields</span></span><span title="Sind im Bereich &bdquo;Therapie der Frau&ldquo; nicht alle gew&uuml;nschten Felder zu finden, dann ist es nat&uuml;rlich m&ouml;glich weitere Details in die Abfrage zu nehmen.  "> in the "Cycle of women" ,  then it is of course possible to implement more details in the query.</span></span></td>
 
−
</tr>
 
−
</tbody>
 
−
</table>
 
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<table style="margin-left: auto; margin-right: auto;" border="0">
 
<table style="margin-left: auto; margin-right: auto;" border="0">

Latest revision as of 09:49, 31 March 2020

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

<tbody> </tbody>
<img src="/images/ReportEd.png" alt="" />

 

 

After opening the Report Editor, you will see on the main screen the Report editor selection with tables and fields, in addition to the Report editor queries which allows you to create and edit queries.

 

Contents

Create and edit queries

<tbody> </tbody>

PersonSelection.png

From the left, drag the section "Persons" and drop it in the center.

 

<tbody> </tbody>

CycleOfWomanTable.png

 

CycleOfWomanDesiredFields.png

Then move "Cycle of women" to the center and select the desired fields.

 

<tbody> </tbody>

Example6Query.png

You can move as many tables as you want and choose the right fields to create some more complex queries that match your requierments.

It's important to know that with every table you move, recalculations are made in the report editor selection to display just tables and fields that can be joined with the current table you have chosen and go with.

The tables and filters choice should be carefully considered, so you will be able to reach the specific requested fields.

 

 

<tbody> </tbody>
<img src="/images/RunButton.PNG" alt="" /> When you click on the tool bar button "Execute", the evaluation is carried out and you get the results.

Example6Result1.png

 

Example6Result2.png

 

Example6Result3.png

 

Example6Result4.png

The query result you get, contains as many columns as the fields you have previously chosen.

 

Apply filters

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/CycleOfWomanFurtherFilter1.png" alt="" />

As a result, sections can be filtered.

For example, "Date of oocyte retrieval" can be set to "NonBlanks".
<img src="/images/CycleOfWomanFurtherFilter2.png" alt="" width="432" height="397" />

Or Cycle treatment performed = "IVF, ICSI"

This filter can be further processed.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Example6CustomFilter1.png" alt="" />

 

<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Example6CustomFilter2.png" alt="" />		 You can also customize and set filters of your choice.

 

Define conditions

<tbody> </tbody>
CycleOfWomanCondition.png

You can define your own conditions.

If you want the time range to be limited, or look for a suitable date of your choice, E.g.: "Date of first thawing", double-clicking on this date opens the window for the condition you want to set. With '+' button, a new condition is applied.

Several conditions can be applied, for example, "is greater" and "less equal".

This condtion filters "Date of first thawing" .You get now all the cycles in which a thawing was made in this period. Inseminations or Aspirations then naturally fall out. If you just want cycles with thawing, this is the correct filter.

You could, for example, Filter on "reference date". Then again, all therapies are considered, but you were just expecting the result of your choice (for example, all pregnancies), so, inevitably another filter should be set.

But you could also choose "Date of ET or latest IUI" to use as a filter, then only therapies in which there has been an insemination or a transfer can be used. It's not the case for not implemented, canceled cycles, or cycles where everything was frozen, thus there was no transfer, and that makes them automatically fall out of the result.

 

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/WomanCycleQueryParameter.png" alt="" />
You can check this box before running your query.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/CycleOfWomanParameter.png" alt="" />
As soon as you run your query, an extra window will appear, and you have the possibility to edit or insert a value as a parameter for the condition you already set.

 

As you can see, there are many ways to make a query, so it should be carefully considered; what methods to use and which filters to set, so no cycles are accidentally excluded, or there is no way to get too many results, since unwanted therapies have been filtered out.

 

More

 

<tbody> </tbody>
<img src="/images/CycleOfWomanRecords.png" alt="" />

From the results, the patient records can be opened by double-clicking on the desired section. 

Double-clicking on the column "Persons." opens the Administration space.

Double-clicking on the column "Cycle." opens the Cycle overview.

 

<tbody> </tbody>
<img src="/images/SaveLoad.PNG" alt="" width="160" height="36" />
 Do not forget to save the query. It can be loaded later.

 

 

<tbody> </tbody>
<a href="/index.php?title=Queries_examples">Back to Queries examples
</a>		 <a href="#top">Back to top</a>