How to create a new query?
From MedITEX - Wiki
To open Report editor, go to Reports -> Report editor in the menu bar.
|Read here more about the queries of the report editor.|
Report editor will open.
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 a sub-group and you will see all fields that are available in this sub-group.
Alternatively you can search the field you need with a keyword search.
For this example, we are going to create a Follicle Aspiration letter.
Assume you need to search a field related to the person name:
Just type the keyword name in the Search field and press Enter. You will be provided with a list of fields that contain that keyword along with their groups and sub-groups. Choose the field you need and click on it.
The group containing that field will open.
Once you have found the sub-group containing the field(s) you need, drag the sub-group 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 sub-group Person, you will not find fields related to the therapy, you will need to link to the sub-group Persons, the subgroup Cycle of women by dragging it from the Group list into the Area for queries as previously described.
Now the desired fields from the sub-group Cycle of women can be selected as seen above for the other fields. When all the needed fields from the sub-group Cycle of women have been selected, another sub-group, if necessary, shall be dragged and dropped. This process is repeated until the query is done.
Defining fields conditions
In some cases it could be useful to restrict values of the selected fields to some conditions.
For example, you may want to select only cycles where the number of collected oocytes is greater than 8.
Simply double-click on the desired field name and the following window will open:
Press the "+" button to add a new filter or condition.
Now you can add conditions and values accordingly.
For this example, only cycles with more than 8 oocytes collected will be displayed.
To add another condition press the "+" button again and enter the information. If you wish to delete a condition or filter, select the condition in the list and press the "-" button.
|The following conditions can be defined:|
Is not equal
Is not empty
Is not like
ZIP code: 12345
No. of children: 0
|If the selected field is a QM field, you can also enable or disable certain QM criterias (function, value, note, data, start and end) for the resulting 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 uncheck 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 you to create arranged lists and statistics more clearly. 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 be automatically grouped by certain fields. To do so, simply check 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 resulting table.
- If you select Query the field value before execution, you will be asked what value to use before running the query. This window is displayed below and you can change de value by clicking on the corresponding field.
Next possible steps
Buttons with a blue dotted frame have special functionalities. Click on it to have more information.
Execute:As soon as you have selected all needed fields you can launch the query by clicking the Execute. The Results window will open.
Clears the content of the selection window. A new selection can be made.
A previously saved query can be loaded by clicking the Open button.
A query can be saved for future use by clicking Save. If the query was created from an existing query it can be saved using Save as. This way, the user can assign a different name to this new query.
Result data records:
Here you can select the number of displayed results.
|Back to How to||Back to top|