Query management tools

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 12: Line 12:
 
</tbody>
 
</tbody>
 
</table>
 
</table>
 +
<table border="0">
 +
<tbody>
 +
<tr>
 +
<td><img 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 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>expert queries &ldquo;Expertenabfrage</strong>&rdquo;) generally appear under the user  <strong>&ldquo;System&rdquo;</strong>.&nbsp; 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 the <strong>list of queries</strong> contained in a given  folder. In the column <strong>&ldquo;Date&rdquo;</strong> is shown the date when a given query was  imported or saved for the last time.</p>
 +
To load the desired query just highlight it and press <strong>"OK"</strong>.</td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p>&nbsp;</p>
 
<p>__TOC__</p>
 
<p>__TOC__</p>
 
<table border="0" width="491" height="317">
 
<table border="0" width="491" height="317">

Revision as of 12:27, 18 December 2012

<tbody> </tbody>
<img src="/images/OpenRE.png" alt="" width="92" height="37" /> Clicking on this button, the window "Saved queries" will pop up.

<img src="/images/SavedQueries.pn.png" alt="" width="704" height="429" />
<tbody> </tbody>
<img 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 src="/images/SystemRE.png" alt="" width="83" height="19" /> Queries that were generated within the system by the program developers (expert queries “Expertenabfrage”) 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 the list of queries contained in a given folder. In the column “Date” is shown the date when a given query was imported or saved for the last time.

To load the desired query just highlight it and press "OK".

 

Contents

<tbody> </tbody>

Selecting a query and right clicking in the box “Queries”, the following menu will appear:
<img src="/images/Letter8.png" alt="" />

 

Change text

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.

Change description

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.

Delete

This option allows to delete selected query. Alternatively a selected query may be deleted pressing the key “DEL” on the keyboard.

Write protection

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’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:

<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 be still 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 action 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 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 (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 “Query builder” usually located in this path: \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 pc.

Import a query

To import a query just select the corresponding option from the menu “Query”. Browse your pc 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>