Query management tools
From MedITEX - Wiki
(Difference between revisions)
| (9 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | <p>To open the <strong>Report editor</strong>, go to <strong>Report -> Report editor </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="" width="519" height="293" /></td> | ||
| + | </tr> | ||
| + | </tbody> | ||
| + | </table> | ||
<p>__TOC__</p> | <p>__TOC__</p> | ||
<table border="0"> | <table border="0"> | ||
| Line 4: | Line 12: | ||
<tr> | <tr> | ||
<td style="text-align: center;"><img src="/images/OpenRE.png" alt="" width="92" height="37" /></td> | <td style="text-align: center;"><img src="/images/OpenRE.png" alt="" width="92" height="37" /></td> | ||
| − | <td>Clicking on this button, the window <strong> | + | <td>Clicking on this button, the window <strong>Saved queries</strong> will open.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td colspan="2" | + | <td colspan="2"><img src="/images/SavedQueries.pn.png" alt="" width="704" height="429" /></td> |
| − | + | ||
| − | </td> | + | |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
| − | <table border="0" width="491" height="317"> | + | <table border="0"> |
| + | <tbody> | ||
| + | <tr> | ||
| + | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/UserRE.png" alt="" /></td> | ||
| + | <td>The left column displays the <strong>folders</strong> containing the queries <strong>saved </strong>or <strong> imported</strong> by different users. <strong>All</strong> created and saved queries are available to all users. <br /></td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SystemRE.png" alt="" width="83" height="19" /></td> | ||
| + | <td>Queries that were generated within the <strong>system</strong> by the program developers<strong> </strong>will generally appear under the user <strong>System</strong>. They can be <strong>executed </strong>and <strong>copied </strong>but <strong>cannot be edited</strong>.</td> | ||
| + | </tr> | ||
| + | <tr> | ||
| + | <td><img src="/images/QueryRight.png" alt="" /></td> | ||
| + | <td> | ||
| + | <p>The right column contains a <strong>list of queries</strong> in a given folder. The column <strong>Date</strong> displays the date when a given query was imported or saved for the last time.</p> | ||
| + | To load the desired query just select it and press <strong>OK</strong>.</td> | ||
| + | </tr> | ||
| + | </tbody> | ||
| + | </table> | ||
| + | <p> </p> | ||
| + | <table style="margin-left: auto; margin-right: auto;" border="0" width="491" height="317"> | ||
<tbody> | <tbody> | ||
<tr> | <tr> | ||
<td> | <td> | ||
| − | <p> | + | <p>Right-clicking a query will display the following menu:</p> |
</td> | </td> | ||
</tr> | </tr> | ||
| Line 26: | Line 51: | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
| + | <p>Each option is explained in detail below.</p> | ||
<p> </p> | <p> </p> | ||
<h2>Change text</h2> | <h2>Change text</h2> | ||
| − | <p> | + | <p>Renames the selected query. Please note that if a template is connected to the query, that template will be accordingly renamed.</p> |
| + | <p> </p> | ||
<h2>Change description</h2> | <h2>Change description</h2> | ||
| − | <p>This option | + | <p>This option allows the user to input a comment related to the selected query. Place the mouse on top of queries to view descriptions.</p> |
| + | <p> </p> | ||
<h2>Delete</h2> | <h2>Delete</h2> | ||
| − | <p> | + | <p>Deletes the selected query. Alternatively, a selected query may be deleted pressing the <strong>Delete </strong>button on the keyboard.</p> |
| + | <p> </p> | ||
<h2>Write protection</h2> | <h2>Write protection</h2> | ||
| − | <p>For queries you have created you can determine | + | <p>For queries you have created you can determine which editing rights other users should have by deciding whether or not to set a write protection. It is only possible to modify another user write-protected query saving it to your own user account. To do this click on the button <strong>Save </strong>after you have performed the desired changes and confirm the following:</p> |
| − | <table border="0"> | + | <table style="margin-left: auto; margin-right: auto;" border="0"> |
<tbody> | <tbody> | ||
<tr> | <tr> | ||
| Line 43: | Line 72: | ||
</table> | </table> | ||
<p>The modified query will be saved in your folder where it can be modified at will.</p> | <p>The modified query will be saved in your folder where it can be modified at will.</p> | ||
| − | <p>A write-protected query can | + | <p>A write-protected query can still be modified by the user that has set the protection.<em> </em></p> |
| + | <p><em><br /></em></p> | ||
<h2>Query import and export</h2> | <h2>Query import and export</h2> | ||
| − | <p>A query may be <strong>sent to the hotline</strong>, <strong>exported </strong>or <strong>imported</strong>.<strong> </strong>To<strong> </strong>do one of this | + | <p>A query may be <strong>sent to the hotline</strong>, <strong>exported </strong>or <strong>imported</strong>.<strong> </strong>To<strong> </strong>do one of this actions just select the desired option.</p> |
| + | <p> </p> | ||
<h3>Sending a query to the hotline</h3> | <h3>Sending a query to the hotline</h3> | ||
<p>Should your query not lead to a result or to an error message, you can send it to the hotline.</p> | <p>Should your query not lead to a result or to an error message, you can send it to the hotline.</p> | ||
<p>The following window will open:</p> | <p>The following window will open:</p> | ||
| − | <table border="0"> | + | <table style="margin-left: auto; margin-right: auto;" border="0"> |
<tbody> | <tbody> | ||
<tr> | <tr> | ||
| − | <td><img src="/images/Hotline.png" alt="" /></td> | + | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Hotline.png" alt="" /></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td> | <td> | ||
| − | <p>Press | + | <p>Press <strong>Yes</strong> to confirm. The file will be saved as <strong>FQB [Name].grd</strong>. “<strong>Name</strong>” here represents the name of the query.</p> |
<p>Now your e-mail program will open. Contact address and standard text have already been filled in and the query to be sent has automatically been attached to the message.</p> | <p>Now your e-mail program will open. Contact address and standard text have already been filled in and the query to be sent has automatically been attached to the message.</p> | ||
</td> | </td> | ||
| Line 62: | Line 93: | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
| + | <p> </p> | ||
<h3>Export a query</h3> | <h3>Export a query</h3> | ||
| − | <p>A query may be exported in order to import it later into another server ( | + | <p>A query may be exported in order to import it later into another server (e.g.: it is possible to send the query to a colleague using MedITEX in another center) or by another user in his/her own folder. If the option export is selected the query will be copied in the folder <strong>Query builder</strong> usually located in "C:\CRITEX\MedITEX IVF\File_Storage\QueryBuilder". The file will be saved as <strong>FQB [Name].grd</strong>. “<strong>Name</strong> here represents the name of the query. This file can be sent and copied into another computer.</p> |
| − | + | ||
| − | + | ||
<p> </p> | <p> </p> | ||
| + | <h3>Import a query</h3> | ||
| + | <p>To import a query just select the corresponding option from the menu <strong>Query</strong>. Browse your computer and select the imported <strong>FQB [Name].grd</strong>. file. Here <strong>Name</strong> represents the name of a previously exported query to import.</p> | ||
<table style="float: right;" border="0"> | <table style="float: right;" border="0"> | ||
<tbody> | <tbody> | ||
Latest revision as of 11:10, 9 January 2013
To open the Report editor, go to Report -> Report editor in the menu bar.
| <img src="/images/ReportEd.png" alt="" width="519" height="293" /> |
Contents |
| <img src="/images/OpenRE.png" alt="" width="92" height="37" /> | Clicking on this button, the window Saved queries will open. |
| <img src="/images/SavedQueries.pn.png" alt="" width="704" height="429" /> | |
| <img style="display: block; margin-left: auto; margin-right: auto;" src="/images/UserRE.png" alt="" /> | The left column displays the folders containing the queries saved or imported by different users. All created and saved queries are available to all users. |
| <img style="display: block; margin-left: auto; margin-right: auto;" src="/images/SystemRE.png" alt="" width="83" height="19" /> | Queries that were generated within the system by the program developers will generally appear under the user System. They can be executed and copied but cannot be edited. |
| <img src="/images/QueryRight.png" alt="" /> |
The right column contains a list of queries in a given folder. The column Date displays the date when a given query was imported or saved for the last time. To load the desired query just select it and press OK. |
|
Right-clicking a query will display the following menu: |
| <img src="/images/Letter8.png" alt="" /> |
Each option is explained in detail below.
Change text
Renames the selected query. Please note that if a template is connected to the query, that template will be accordingly renamed.
Change description
This option allows the user to input a comment related to the selected query. Place the mouse on top of queries to view descriptions.
Delete
Deletes the selected query. Alternatively, a selected query may be deleted pressing the Delete button on the keyboard.
Write protection
For queries you have created you can determine which editing rights other users should have by deciding whether or not to set a write protection. It is only possible to modify another user write-protected query saving it to your own user account. To do this click on the button Save after you have performed the desired changes and confirm the following:
| <img src="/images/Letter9.png" alt="" width="352" height="145" /> |
The modified query will be saved in your folder where it can be modified at will.
A write-protected query can still be modified by the user that has set the protection.
Query import and export
A query may be sent to the hotline, exported or imported. To do one of this actions just select the desired option.
Sending a query to the hotline
Should your query not lead to a result or to an error message, you can send it to the hotline.
The following window will open:
| <img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Hotline.png" alt="" /> |
|
Press Yes to confirm. The file will be saved as FQB [Name].grd. “Name” here represents the name of the query. Now your e-mail program will open. Contact address and standard text have already been filled in and the query to be sent has automatically been attached to the message. |
Export a query
A query may be exported in order to import it later into another server (e.g.: it is possible to send the query to a colleague using MedITEX in another center) or by another user in his/her own folder. If the option export is selected the query will be copied in the folder Query builder usually located in "C:\CRITEX\MedITEX IVF\File_Storage\QueryBuilder". The file will be saved as FQB [Name].grd. “Name here represents the name of the query. This file can be sent and copied into another computer.
Import a query
To import a query just select the corresponding option from the menu Query. Browse your computer and select the imported FQB [Name].grd. file. Here Name represents the name of a previously exported query to import.
| <a href="/index.php?title=MedITEX_IVF_manual">Back to the MedITEX IVF menu </a> | <a href="#top">Back to top</a> |