How to create a new query?

Revision as of 13:35, 18 December 2012

To open the report editor window go to Reports -> Report editor.

Selecting the needed fields

To select the fields in order to build a query you need to browse the content of the subgroups.

If you double-click on a group you will see all available sub-groups . Double-click on a sub-group and you will see all fields that are available in this group.

Alternatively you can search the field you need with a keyword search.

Assume you need to search a field related to the person’s name:

Just type the keyword “name” in the Search field and press "Enter". You will provided with a list of fields that contain that keyword along with their group and sub group. Choose the field you need and click on it.

The group containing the field will open.

Once you have found the sub-group containing the field(s) you need, drag the subgroup from the Group list into the Area for queries.

To select a field (i.e. the “First name” field) for the query, check the empty box. In order to build our Follicle aspiration discharge letter you may need to select other fields of this sub group such as “Surname”. “Partner: surname” and “Partner: name”.

Let’s go on building our discharge letter.

Since in the subgroup person you won’t find fields related to the therapy you’ll need to link to the subgroup “Persons” the subgroup “Cycle of women” dragging this subgroup from the Group list into the Area for queries as previously described.

Now the desired fields from the subgroup “Cycle of women” can be selected as seen above for the other fields. When all the needed fields from the subgroup “Cycle of women” have been selected another sub-group, if necessary, shall be dragged and dropped and so on until the query it is done.

Keep in mind that the order of the sub-groups added to a query has an effect on the way the results are displayed ("logical cascade"). In the example (picture) patients which have received cycles would be displayed after the query and not cycles that have been assigned to certain patients.

Keep in mind that the order of the sub-groups added to a query has an effect on the way the results are displayed ("logical cascade"). In the example (picture) patients which have received cycles would be displayed after the query and not cycles that have been assigned to certain patients.

If a QM Field is created but it is not previously filled in, it won’t be available in the related Report Editor’s subgroup.

Defining fields' conditions

In some cases it could be useful to restrict the values of the selected fields to some condition.

For example you may want to select only cycles where the # of collected oocytes is > than 8.

Simply double-click on the desired field name and the following window will open:

<img src="/images/RE4.png" alt="" width="390" height="404" />	Press the "+" button to add a new filter or condition. Now you can add condition and value accordingly. In the example, all the cycle with more that 8 oocyte collected will be selected. To add another condition press to "+"-button again and enter your information. If you wish to delete a condition or filter again, select the condition in the list and press the "-" - button.
<img src="/images/RE5.png" alt="" width="390" height="551" />	The following conditions can be defined:
	Condition: Is equal Is not equal Is greater Is smaller Is not empty Is empty Is like Is not like	Example: Gender: F ZIP code: 12345 No. of children: 0 BMI: 25 previous PG Chrom. anomaly Surname: Miller Surname: Miller
	If the selected field is a QM field, you can also enable or disable certain QM criteria (function, value, note, data, start and end) for the result table.

You can add and combine different conditions for any field. Two or more conditions may be linked logically with "AND" or “OR” when pre-filtering.

If you untick the box "and should appear in the results list", your query will be filtered but the field itself will not be displayed in the list. This can help to create clearly arranged lists and statistics. Example: You wish to analyze only the male patients and limit the list to men.

You can also decide if the list of results should automatically grouped by certain fields. To do so, simply tick the box "and the result should be grouped by this field" when adding a condition. The order of your definition is decisive for the graphical representation of the result table.

Next possible steps

<a href="/index.php?title=Result_management"><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExecuteRE.png" alt="" width="89" height="38" /></a>	Execute button: As soon as you have selected all needed fields you can launch the query by clicking the "Execute"- button. The Report editor: <a href="/index.php?title=Result_management">results</a> window will open.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/NewRE.png" alt="" width="88" height="36" />	New: Clears the contents of the selection window. A new selection can be made.
<a href="/index.php?title=How_to_load_a_query%3F"><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/OpenRE.png" alt="" width="92" height="37" /></a>	Loading a query: A saved query can be simply by clicking on the <a href="/index.php?title=How_to_load_a_query%3F">"Open"</a>-button. A new window, "Saved queries", will pop up.
<a href="/index.php?title=How_to_save_a_query%3F"><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SaveRE.png" alt="" width="89" height="83" /></a>	Saving a query: A query can be saved for future use by clicking on "Save"-button. If the query was created from an existing query it can be saved choosing <a href="/index.php?title=How_to_save_a_query%3F">“Save as”</a>. In this way the user can assign to the new query a name different from the parent query.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ResultRE.png" alt="" width="208" height="91" />	Result data records: A selection of shown Results can be chosen here.

@@ Line 126: / Line 126: @@
 </ul>
 <p>&nbsp;</p>
-<p><strong><span id="result_box" class="short_text" lang="en"><span class="hps">Choose</span> <span class="hps">your next</span> <span class="hps">step</span>:</span></strong></p>
+<h2><span id="result_box" class="short_text" lang="en"><span class="hps">Next</span> <span class="hps">possible steps</span></span></h2>
 <table border="0">
 <tbody>

How to create a new query?

From MedITEX - Wiki

Revision as of 13:35, 18 December 2012

Contents

Selecting the needed fields

Defining fields' conditions

Next possible steps