Mercurial > hg > ltpda

comparison m-toolbox/html_help/help/ug/repo_gui_query.html @ 0:f0afece42f48

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Import.
author Daniele Nicolodi <nicolodi@science.unitn.it>
date Wed, 23 Nov 2011 19:22:13 +0100
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f0afece42f48
1 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
2 "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
3
4 <html lang="en">
5 <head>
6 <meta name="generator" content=
7 "HTML Tidy for Mac OS X (vers 1st December 2004), see www.w3.org">
8 <meta http-equiv="Content-Type" content=
9 "text/html; charset=us-ascii">
10
11 <title>Querying the contents of a repository (LTPDA Toolbox)</title>
12 <link rel="stylesheet" href="docstyle.css" type="text/css">
13 <meta name="generator" content="DocBook XSL Stylesheets V1.52.2">
14 <meta name="description" content=
15 "Presents an overview of the features, system requirements, and starting the toolbox.">
16 </head>
17
18 <body>
19 <a name="top_of_page" id="top_of_page"></a>
20
21 <p style="font-size:1px;">&nbsp;</p>
22
23 <table class="nav" summary="Navigation aid" border="0" width=
24 "100%" cellpadding="0" cellspacing="0">
25 <tr>
26 <td valign="baseline"><b>LTPDA Toolbox</b></td><td><a href="../helptoc.html">contents</a></td>
27
28 <td valign="baseline" align="right"><a href=
29 "repo_gui_submit.html"><img src="b_prev.gif" border="0" align=
30 "bottom" alt="Submitting objects to a repository"></a>&nbsp;&nbsp;&nbsp;<a href=
31 "repo_gui_hlq.html"><img src="b_next.gif" border="0" align=
32 "bottom" alt="Performing High-Level Queries"></a></td>
33 </tr>
34 </table>
35
36 <h1 class="title"><a name="f3-12899" id="f3-12899"></a>Querying the contents of a repository</h1>
37 <hr>
38
39 <p>
40 <p>
41 Querying an LTPDA repository is done using standard SQL statements. The repository GUI
42 presents the user with the possibility to graphically build SQL statements which avoids
43 learning SQL syntax. Currently, the SQL statements that can be built in this way are
44 restricted to queries on a single database table. High-level queries, searching more database tables at once, are implemented in the following panel.
45 </p>
46 <p>
47 The repository GUI has a query panel which looks like the figure below:
48 </p>
49 <br>
50 <br>
51 <img src="images/repo_gui_query_1.png" alt="Repo GUI Query">
52 <br>
53 <br>
54 <p>
55 In this figure, you see that the user has built a query to select all objects
56 submitted on the 24th February 2008. The results will contain the object id,
57 the submitted date, the experiment title, the experiment description, and the analysis
58 description. The results will be sorted in descending order of the object id.
59 </p>
60 <p>
61 Executing the query (click the 'Execute query' button) produces the results table
62 shown below.
63 </p>
64 <br>
65 <br>
66 <img src="images/repo_gui_query_2.png" alt="Repo GUI Query Results">
67 <br>
68 <br>
69 <p>
70 The query string that is actually executed is presented in the text edit
71 box above the 'Execute query' button. This query string can be edited to allow for finer
72 control over the query. This is meant for users who already have a working knowledge of MySQL
73 SQL syntax.
74 </p>
75
76
77 </p>
78
79 <br>
80 <br>
81 <table class="nav" summary="Navigation aid" border="0" width=
82 "100%" cellpadding="0" cellspacing="0">
83 <tr valign="top">
84 <td align="left" width="20"><a href="repo_gui_submit.html"><img src=
85 "b_prev.gif" border="0" align="bottom" alt=
86 "Submitting objects to a repository"></a>&nbsp;</td>
87
88 <td align="left">Submitting objects to a repository</td>
89
90 <td>&nbsp;</td>
91
92 <td align="right">Performing High-Level Queries</td>
93
94 <td align="right" width="20"><a href=
95 "repo_gui_hlq.html"><img src="b_next.gif" border="0" align=
96 "bottom" alt="Performing High-Level Queries"></a></td>
97 </tr>
98 </table><br>
99
100 <p class="copy">&copy;LTP Team</p>
101 </body>
102 </html>