1
<HTML><HEAD><TITLE>Using lists</TITLE></HEAD><BODY>
3
A list is a very central element of the TOra user interface and is a standard way to display
4
information in a grid. Here is an example of a list.<P>
5
<IMG SRC=images/lists.png BORDER=1><P>
6
<H2>Navigating a list</H2>
7
If a list does not fit into it's designated area on the screen it will get scrollbars that
8
can be used to navigate the entire contents of the list. There are also the usual key bindings <B>left</B>,
9
<B>right</B>, <B>up</B>, <B>down</B>, <B>page up</B>, <B>page down</B> etc...<P>
10
Lists can be hierarchical as can be seen in the screenshot above. When there are child items
11
that are not displayed a <B>+</B> is displayed to the left of the row. Clicking the <B>+</B> will
12
expand the row and display the child items. You can also use the <B>right</B> key to expand
13
child items and <B>left</B> key to collapse them.<P>
15
Result lists are lists that display the result of a query from the database. Only a configured
16
amount of rows are initially read (See <A HREF=database.html>options</A> for more information),
17
although enough items to fill the screen is always read if available. To read more items from
18
the queries simply scroll down. If you want to scroll faster use <B>page down</B> which will read
19
an entire screen of data at a time from the query. If you want to read all the data available
20
you can use the <B>Edit|Read All</B> menu item.
21
<H2>Manipulating lists</H2>
22
In a list you can change the sort order by pressing the header of the list to sort on the column
23
whose header you clicked. Clicking the same column again will reverse the sort order. Columns
24
that contain numerical data (Regardless of database format) will be sorted as numbers (2 before
25
10). Observe that not all lists can be sorted in a different sort order.<P>
26
You can also rearrange the column order by dragging the heading of a column to another place.<P>
27
<H2>Accessing the contents of a field</H2>
28
The contents of a field (Specific row and column of a list) can be copied either by
29
double-clicking the field, or selecting copy from the context menu available by right-clicking
30
on the field. You can also drag the contents of a field to an editor.<P>
31
If the contents is too long to be visible in the list you will get a tooltip with all of the
32
contents if you place the mouse over the field for a short while (As seen in the screenshot).
33
If this is not enough you can display the contents of a field in a separate window by accessing
34
the context menu of the field and selecting <B>display in editor</B>.<P>
35
You can also place a line in the <A HREF=common.html#param>bind parameter</A> cache by
36
double clicking on a line. The bind name will be the same as the column name in lowercase.<P>
37
<H2>Other list functionality</H2>
38
Lists can always be printed by selecting the <B>File|Print</B> menu item.<P>
39
You can also save a list as a text file by selecting <B>File|Save</B> menu item. Any graphics
40
in the list will be discarded and all fields will be left justified in the output.<P>
41
In the context menu for the list you can also select the entry <B>edit SLQ</B> in which you
42
can edit the SQL used to generated the list. If there is no single SQL used to generate the
43
list you will not find any SQL, however you will usually be pointed in roughly the right direction
44
in the <A HREF=sqledit.html>sql editor</A> (Where you can also find more information about
45
the concept of SQL dictionary TOra uses).
b'\\ No newline at end of file'