Last medical histories

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 101: Line 101:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
−
<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 cycles 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 therapies 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 medical histories 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 data have been filtered out.</span></span></p>
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 
<h3>More</h3>
 
<h3>More</h3>

Revision as of 09:26, 29 July 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>

LastMedicalHistories.png

LastMedicalHistoriesFields.png

Then move "Last medical histories of a couple" to the center and select the desired fields.

 

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

 

Apply filters

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

As a result, sections can be filtered.

For example, "Last medical histories of a couple.F:Sterility:Factor" can be set to "Blanks".
<img src="/images/LastMedicalHistoriesFilter2.png" alt="" />

Or Last medical histories of a couple:M:Smoker = "1" which will only display rows with "Yes".

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

 

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

 

Define conditions

<tbody> </tbody>
LastMedHisCondition.png

You can define your own conditions.

If you want the content of the field to be limited, or look for a specific condition, E.g.: "M: Fertility impairment factors", 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 than" and "less equal".

This condtion filters "M: Fertility impairment factors" .You get now all the last medical histories in which the fertility impairment factor meets the impaired spermiogram. Anejaculations or Neurogenic disorder then naturally fall out.  

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.

And you could also choose "Infertility since" to use as a filter, then only medical histories meeting the condition you set can be used.  

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 medical histories are accidentally excluded, or there is no way to get too many results, since unwanted data have been filtered out.

 

More

 

<tbody> </tbody>
<img src="/images/LastMedHisRecord.png" alt="" width="625" height="261" />

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

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

Double-clicking on the column "Last medical histories of a couple." opens the Medical history 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>