Semen analysis

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 93: Line 93:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
 +
<p>&nbsp;</p>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SemenAnalysisQueryParameter.png" alt="" /></td>
 +
</tr>
 +
<tr>
 +
<td style="text-align: center;">You can check this box before running your query.</td>
 +
</tr>
 +
<tr>
 +
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SemenAnalysisParameter.png" alt="" /><br /></td>
 +
</tr>
 +
<tr>
 +
<td>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.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 
<p><span id="result_box" lang="en"><span title="Wie man sieht gibt es viele M&ouml;glichkeiten eine Abfrage zu gestalten, d.h.">As you can see, there are many ways to make a query, so </span><span title="es sollte gut &uuml;berlegt werden, mit welcher Methode und welchen Filtern man zu der gew&uuml;nschten Ergebnisliste kommt (sodass nicht versehentlich Zyklen ausgeschlossen werden, oder man zu viele Ergebnisse bekommt, da nicht gew&uuml;nschte Therapien rausgefiltert wurden).  ">it should be carefully considered; what methods to use and which filters to set, so no semen analysis are <span id="result_box" lang="en"><span title="es sollte gut &uuml;berlegt werden, mit welcher Methode und welchen Filtern man zu der gew&uuml;nschten Ergebnisliste kommt (sodass nicht versehentlich Zyklen ausgeschlossen werden, oder man zu viele Ergebnisse bekommt, da nicht gew&uuml;nschte Therapien rausgefiltert wurden).  ">accidentally </span></span>excluded, or there is no way to get too many  results, since unwanted rows have been filtered out.</span></span></p>
 
<p><span id="result_box" lang="en"><span title="Wie man sieht gibt es viele M&ouml;glichkeiten eine Abfrage zu gestalten, d.h.">As you can see, there are many ways to make a query, so </span><span title="es sollte gut &uuml;berlegt werden, mit welcher Methode und welchen Filtern man zu der gew&uuml;nschten Ergebnisliste kommt (sodass nicht versehentlich Zyklen ausgeschlossen werden, oder man zu viele Ergebnisse bekommt, da nicht gew&uuml;nschte Therapien rausgefiltert wurden).  ">it should be carefully considered; what methods to use and which filters to set, so no semen analysis are <span id="result_box" lang="en"><span title="es sollte gut &uuml;berlegt werden, mit welcher Methode und welchen Filtern man zu der gew&uuml;nschten Ergebnisliste kommt (sodass nicht versehentlich Zyklen ausgeschlossen werden, oder man zu viele Ergebnisse bekommt, da nicht gew&uuml;nschte Therapien rausgefiltert wurden).  ">accidentally </span></span>excluded, or there is no way to get too many  results, since unwanted rows have been filtered out.</span></span></p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>

Revision as of 14:52, 4 August 2016

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>
FieldsSelection.png

Select the desired fields.

With a right-click on this area, the fields can be sorted by "selection".

 

<tbody> </tbody>

PersonsSemenAnalysis.png

SemenAnalysisFields.png

Then move "Semen analysis" to the center and select the desired fields.

 

<tbody> </tbody>
<img src="/images/SemenAnalysisRun.png" alt="" /> When you click on the tool bar button "Run", the evaluation is carried out and you get the results.
SemenAnalysisResult.png

 

Apply filters

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

As a result, sections can be filtered.

For example, "Semen analysis.Appearance" can be set to "Normal, Flocculent".
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SemenAnalysisFilter2.png" alt="" />

Or Semen analysis.Native: Concentration = 4,000

This filter can be further processed.

 

Define conditions

<tbody> </tbody>
SemenAnalysisCondition.png

You can set the conditions you want.

If you want the rows to be limited, or look for a specific value, E.g.: "Native: PH", double-clicking on this record 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 "Native: PH" .You get now all the cycles in which the PH value meets the condition you have set.  

 

<tbody> </tbody>
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SemenAnalysisQueryParameter.png" alt="" />
You can check this box before running your query.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SemenAnalysisParameter.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 semen analysis are accidentally excluded, or there is no way to get too many results, since unwanted rows have been filtered out.

 

More

<tbody> </tbody>
ExaminationSemenAnalysis.png

You can directly create your query using the Semen analysis, and you will get as a result all the Examinations / Medical histories records without depending or being attached to any other table (like we previously did with Persons table).

Otherwise, you can start by dragging and dropping Persons table, and customizing your query with your chosen fields, so you can later use it for demographics letter or to generate statistics.

 

<tbody> </tbody>
<img src="/images/SemenAnalysisRecord.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 "Semen analysis." opens the male lab diagnostics.

 

<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>