Database Editor

From GWAVA4

The Database Editor allows you to view the core gwavaman.db configuration database, and allows you to make changes to it.

NOTE:Severe damage can occur to your GWAVA System if you delete or change records without proper knowledge. We do not recommend using this tool unless you are instructed to do so by GWAVA Support.

To access the Database Editor, open the System Management pane on the left side of the GWAVAMAN interface. Then expand out System Tools and click on Database Editor.

You'll be warned before continuing.

A new browser window will open up:

You can select to open the databases in either read-only (safest when browsing, and strongly recommended), or read-write mode.

The examples below will show the read-write interface, however the interface is more or less identical for both modes except

• As "read-only" implies, you cannot change the underlying data in any form in read-only mode.
• In read-write, you can update, delete, or clone a record.
• Only the main configuration database can be opened in read-write mode. The Host and Replication table can only be viewed in read-only mode.

Assuming you opened the configuration database in read-write mode, here's an example of what you would see:

A basic search

There's a lot on this page. Let's start with entering basic search criteria

You set the basic search criteria by selecting the field for comparison, the comparison operator (equals or like), and the search term. All criterion are AND'ed together, so this example will search for all records with SZ_CATEGORY=SERVICE and SZ_SUBCATEGORY=LINK. You may specify up to 4 criterion. To activate the search, click on the button.

You may also limit the search to specific objects in the database. This is an advanced feature that allows experienced support personnel to choose items relating only to a specific engine or interface or other object. For example, limiting the search to "Engine of MyPOA" below will show only records related to the configuration of the MyPOA scanning engine.

Controlling the results displayed

The DB Editor doesn't always return all the results of a query, since there could be thousands of rows returned, which would be a slow operation in a web browser. You may control how many results are returned, and are warned if more entries may exist.

The maximum number of results is how many rows will be returned. The return result offset allows paging through many results. For example, if there are 500 rows, and you view 100 rows at a time, you could change the offset to 101 to view the next 100 results, then 201, etc.

Changing the Records

This is only possible in read-write mode.

To edit a record and save the changes, alter the fields of the records as you wish, and click the button next to the edited row.

To delete a row, click the button next to the row. This operation cannot be undone.

To copy a row's contents and create a new row, click the button next to the row.