Query management tools

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
<p>To open the <strong>Report editor</strong>, go to <strong>Report -&gt; 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>"Saved queries"</strong> will pop up.</td>
+
<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>
<p><img src="/images/SavedQueries.pn.png" alt="" width="704" height="429" /></p>
+
</td>
+
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
 
</table>
 
</table>
 
<p>&nbsp;</p>
 
<p>&nbsp;</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>&nbsp;</p>
 +
<table style="margin-left: auto; margin-right: auto;" border="0" width="491" height="317">
 
<tbody>
 
<tbody>
 
<tr>
 
<tr>
 
<td>
 
<td>
<p><strong>Selecting a query</strong> and right clicking in the box <strong>&ldquo;Queries&rdquo;</strong>, the following menu will appear:</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>&nbsp;</p>
 
<p>&nbsp;</p>
 
<h2>Change text</h2>
 
<h2>Change text</h2>
<p>Choosing the option change text will allow to rename the selected query. Please note that if a template is connected to the query, that template will be accordingly renamed.</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>&nbsp;</p>
 
<h2>Change description</h2>
 
<h2>Change description</h2>
<p>This option allow the user to input a comment related to the selected query. The comment can be shown passing the cursor on the query title.</p>
+
<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>&nbsp;</p>
 
<h2>Delete</h2>
 
<h2>Delete</h2>
<p>This option allows to delete selected query. Alternatively a selected query may be deleted pressing the key &ldquo;DEL&rdquo; on the keyboard.</p>
+
<p>Deletes the selected query. Alternatively, a selected query may be deleted pressing the <strong>Delete </strong>button on the keyboard.</p>
 +
<p>&nbsp;</p>
 
<h2>Write protection</h2>
 
<h2>Write protection</h2>
<p>For queries you have created you can determine yourself which editing rights other users should have by deciding whether or not to set a write protection. It is only possible to modify a another user&rsquo;s 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:</p>
+
<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 be still modified by the user that has set the protection.<em>&nbsp;</em></p>
+
<p>A write-protected query can still be modified by the user that has set the protection.<em>&nbsp;</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 action just select the desired option.</p>
+
<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>&nbsp;</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 &ldquo;Yes&rdquo; to confirm. The file will be saved as <strong>FQB [Name].grd</strong>. &ldquo;Name&rdquo; here represents the name of the query.</p>
+
<p>Press <strong>Yes</strong> to confirm. The file will be saved as <strong>FQB [Name].grd</strong>. &ldquo;<strong>Name</strong>&rdquo; 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>&nbsp;</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 (eg it is possible to send the query a colleague using MedITEX in another center) or by another user in his/her on folder. If the option export is selected the query will be copied in the folder &ldquo;Query builder&rdquo; usually located in this path: \CRITEX\MedITEX IVF\File_Storage\QueryBuilder. The file will be saved as <strong>FQB [Name].grd</strong>. &ldquo;Name&rdquo; here represents the name of the query. This file can be sent and copied into another pc.</p>
+
<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>. &ldquo;<strong>Name</strong> here represents the name of the query. This file can be sent and copied into another computer.</p>
<h3>Import a query</h3>
+
<p>To import a query just select the corresponding option from the menu &ldquo;Query&rdquo;. Browse your pc and select the imported <strong>FQB [Name].grd</strong>. file. Here &ldquo;Name&rdquo; represents the name of a previously exported query to import.</p>
+
 
<p>&nbsp;</p>
 
<p>&nbsp;</p>
 +
<h3>Import a query</h3>
 +
<p>To import a query just select the corresponding option from the menu&nbsp;<strong>Query</strong>. Browse your computer and select the imported <strong>FQB [Name].grd</strong>. file. Here&nbsp;<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.

<tbody> </tbody>
<img src="/images/ReportEd.png" alt="" width="519" height="293" />

Contents

<tbody> </tbody>
<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" />

 

<tbody> </tbody>
<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.

 

<tbody> </tbody>

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:

<tbody> </tbody>
<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:

<tbody> </tbody>
<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.

<tbody> </tbody>
<a href="/index.php?title=MedITEX_IVF_manual">Back to the MedITEX IVF menu </a> <a href="#top">Back to top</a>