diff m-toolbox/html_help/help/ug/repo_gui_query_content.html @ 0:f0afece42f48

Import.
author Daniele Nicolodi <nicolodi@science.unitn.it>
date Wed, 23 Nov 2011 19:22:13 +0100
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/m-toolbox/html_help/help/ug/repo_gui_query_content.html	Wed Nov 23 19:22:13 2011 +0100
@@ -0,0 +1,36 @@
+<p>
+  Querying an LTPDA repository is done using standard SQL statements. The repository GUI
+  presents the user with the possibility to graphically build SQL statements which avoids
+  learning SQL syntax. Currently, the SQL statements that can be built in this way are 
+  restricted to queries on a single database table. High-level queries, searching more database tables at once, are implemented in the following panel.
+</p>
+<p>
+  The repository GUI has a query panel which looks like the figure below:
+</p>
+<br>
+<br>
+<img src="images/repo_gui_query_1.png" alt="Repo GUI Query">
+<br>
+<br>
+<p>
+  In this figure, you see that the user has built a query to select all objects 
+  submitted on the 24th February 2008. The results will contain the object id, 
+  the submitted date, the experiment title, the experiment description, and the analysis
+  description. The results will be sorted in descending order of the object id.
+</p>
+<p>
+  Executing the query (click the 'Execute query' button) produces the results table
+  shown below.
+</p>
+<br>
+<br>
+<img src="images/repo_gui_query_2.png" alt="Repo GUI Query Results">
+<br>
+<br>
+<p>
+  The query string that is actually executed is presented in the text edit
+  box above the 'Execute query' button. This query string can be edited to allow for finer
+  control over the query. This is meant for users who already have a working knowledge of MySQL 
+  SQL syntax.
+</p>
+