<< Click to Display Table of Contents >>

Manipulating the Data Grid

Top Previous Next

Most information in Hora's grids is represented in a tabular layout. It is possible to change this view to focus on just one table row.

The View tabs

On some of Hora's tabbed sheets, it is possible to switch back and forth between

Grid View

Text View

Tree View

using a set of tabs at the top of the grid.

 

Shown below is the data content of the EMPLOYEES in the HR sample schema, with the Grid View in effect.

 

grid view

 

Clicking on Record View results in an up-close look at the current row.

 

 

record view

 

Text View allows the raw data to be captured with the mouse and pasted into a text editor.

 

text view

 

Chart View presents the data in a highly customizable graphical chart. A slider on the right side lets you adjust the number of categories (i.e. x-axis values) shown per page. Multiple diagram types such as Pie diagram, Bar diagram, Column diagram or Line diagram are available.

 

chart view

 

The Tree View can show data from a relational database in a hierarchical way.

 

tree view

 

As is the case for Chart View, Tree View is not limited to the Data Contents page. This powerful presentation is available for all views. You can even apply it to the results of a SQL query.

 

 

The Pivot View allows you to view and analyze your data with the help of pivot tables (or Cross Tables).

 

Start to create your own customized Pivot Table by dragging the appropriate items from the list into the three different fields.

pivot1

 

 

 

The example below shows an example pivot view of the ORDERS table that you can find in Oracle's OE (Order Entry) sample schema.

pivot2

 

 

 

In-Memory Mode

On grids such as these, the In-Memory Mode check box causes the grid contents to be downloaded to your PC, where they can be further arranged in ways that are not available when queries are sent to the database.

You'll see the following popup window the first time that you check the box:

dlgGrid 2

It's worth reading this message at least once—then you can turn it off. You might not want to use this mode with a huge table, but in the example above, the overhead is relatively light.

If you bring the contents of a column into memory, you can then see the effects of the advanced grouping, sorting and filtering options that have become available starting with Hora 7.

Grouping

While in in-memory grid mode, you can group the contents of the grid by dragging a column header to the grey bar at the top of the grid:

grouping1

 

Now, if you drag another column to the grouping bar, it is removed from the main grid, and two levels of grouping are the result:

 

grouping2

 

Sorting

In the illustration above the grouped results are sorted in ascending order, as indicated by the triangles to the right of the column names. Just click on the column name to reverse the direction of the sort.

(This applies to the columns in the grid as well as those in the grouping bar.)

You can also sort on as many columns as you like. All you need to do is click the primary sort column heading once, then shift-click the column headings for the secondary sort keys, in order.

Filtering

To see some meaningful examples of filtering at work, we can look at the contents of ZOO.ENCLOSURE. Clicking on the filter icon to the right of a column name causes the Filtering dialog to appear.  To select all enclosures with a size greater than 200, click the filter icon for ENCLOSURE SIZE, then select (Custom...). When you fill in the fields, filtering takes place, and the result is displayed in a bar at the bottom of the grid.

You can even add an additional filter at a later time.

 

filter

 

At the end of the specification, the revised contents are shown, as is the revised filter.

 

filter2

Applying aggregations

Using the In-Memory mode when grouping is in effect, it is possible to apply aggregations to numeric columns by right-clicking in the footer bar under a group and selecting a aggregation function from the popup menu.

 

dlgGrid 9

 

Here, Average has been applied to the SALARY column, and COUNT to ID. It is also possible to click the footer for the entire table to specify functions there.

Options on other grids

You will also find it quite easy to take advantage of various display possibilities on some of Hora's other grids. If you are familiar with previous versions of Hora, you will see that some of the sheets that were formerly divided into a main grid and one or more subgrids now use a system of expanding and collapsing views instead. An example would be the Columns sheet of the Tables page:

 

dlgGrid 5a

 

When you click the plus sign to the left of each column name, information about constraints applicable to the column are shown by default. As you open more columns, you see any available constraint data for those, as well. Note that the Constraints left tab is slightly longer than the others, showing that it is active. When you click another tab, the display changes for all selected column names.

It's worth noting that the information about the columns has been grouped for you by column name by default. You can override the grouping by right-clicking on the grid, choosing Grid View from the context menu, then Show Group By Box, then dragging first Data Type, then Name to the Group By bar.

 

dlgGrid 5

 

Other grid-related functions

In addition to grouping, sorting and filtering, the following functions are also available in most of Hora's grids, using the mouse:

You can drag the column headings to change the order of appearance.

You can click the tab at the top of the grid to refresh the view.

You can drag the border between columns to increase or decrease the column width.