<< Click to Display Table of Contents >>

Display and Filtering Tables and Views

Top Previous Next

The display formats used by in the Data Contents Browser are the same as on the Data Contents sheet of the Tables Page.

The same views are available: the grid (or spreadsheet) view appears by default. Different views can be selected with the tabs on the top of the grid.

The Data Contents Browser also lets you view the table ordered by the contents of a particular column if you drag that column to the dark blue bar at the top.

 

frmDataBrowser_GroupBy

 

The context menu for the data grid is very similar to that of the Data Contents sheet of the Tables page, and is reproduced here for reference. The buttons also appear on the Toolbar.

 

29_First

First

Navigates to the first record.

30_Prior

Prior

Navigates to the prior record.

31_Next

Next

Navigates to the next record.

32_Last

Last

Navigates to the last record.

33_Insert

Insert

Inserts an empty record and switches into edit mode.

34_InsertCopy

Insert Copy

Inserts a copy of the current record and switches to edit mode.

35_Delete

Delete

Deletes the current record.

36_Edit

Edit

Switches the current record into edit mode.

37_Post

Post

Posts the changed record to the database server, causing the update to be committed.

38_Cancel

Cancel

Cancels changes made to the current record.

 

Filter by selection

Filters the result set to rows containing the selected cell value in the current column.

 

Goto master table

The menu displays a submenu that shows the names of all master tables of the current table. The foreign-key name in [braces] allows you to choose between multiple master tables.

The data grid will change to display the contents of the selected table. A filter is generated that ensures that you see only data matching the selected row of the current table. You will see only the master record referenced by the foreign key..

 

Goto detail table

The menu displays a submenu that shows the names of all detail tables of the current table. The foreign-key name in [braces] lets you choose between multiple detail tables.

The data grid will change to display the contents of the selected table. A filter is generated that ensures that you see only data matching the selected row of the current table. You will see only detail records referenced by the foreign key.

 

Number as MS windows color

Sometimes MS-Windows colors are stored in the database as their numerical representations. The menu item shows the windows color dialog to let you choose any Windows color and store its numerical representation in the selected field.

158_Report

Report

Invokes the Reporting facility.

157_Excel

Excel export

Automatically exports the table to a Microsoft Excel spreadsheet

 

XML Export

Invokes the XML Export dialog.

 

Export Wizard

Invokes the Export Wizard facility.

 

Import Wizard

Invokes the Import Wizard facility.

112_InsertScript

Create INSERT script

Creates a series of INSERT statements from the current result set. This simplifies data transfer to other applications, version management of basic stock data and data comparison between different databases.

 

Create UPDATE script

Creates a series of UPDATE statements from the current result set. Editing this script would allow selected columns and rows to be updated with new values.

 

Grid View

For more information, see object window

Filtering

If you bring a table into the browser using the Go to master table or Go to detail table context menu items, a filter based on the current row of the current table will be automatically applied.

In this case, as in other cases where filtered data is being viewed, the filter can be turned off, and the grid repopulated by clicking on Clear Filter.

If you bring a table into the Data Contents Browser by clicking on its Open New Table tab, you are also given the opportunity to apply a filter before displaying any rows.

Previously used filters are available from the Filter field's drop-down box.

When viewing either an entire table or a filtered table, you have the option of applying another filter either by coding it in the Filter field, or by invoking the graphic filter builder.

To create a new filter graphically, you will need to open the Where condition dialog by clicking on the button with the ellipsis. This will open a dialog that lets you select a column, then apply a condition to it. The condition may be built either by clicking on buttons, or may be entered directly into the Condition field. In this example, one filter condition has already been created (COUNTRY_ID= 'US').

 

frmDataBrowser_Filter1

 

Once we click the Add to Filter button, the Filter field will be updated, and the filter will automatically be applied, as seen here:

 

frmDataBrowser_Filter2

 

Clicking Replace Filter will also cause the grid to be immediately updated with the new filter condition.

If you select a filter from the drop-down box, you will need to click the Apply Filter button at the top of the Data Contents Browser window.

The Clear Filter button automatically updates the grid with the entire contents of the table.