Data browser

Data Browser displays the data of table currectly selected in connection tree. Supports quick search, sorting, paging, history, canceling of loading, etc.

• In the upper bar is available quick search (just enter the search text box next to the icon ) and press Enter. Search is performed on data of whole table, rather than loaded page data (so there is request database server)
• Icon ) displays tool panel for filtering.
• Icon ) displays tool panel table with referenced data (master / detail view).
• Icon ) displays tool panel for browsing history (it makes sense in combination with a master / detail views).
• Icon ) resets view (sets the default sorting, filtering is turned off).

Filtering Tool Bar

This panel allows you to specify the WHERE condition to run SQL command. SQL syntax is the same as syntax used by database.

Reference Tool Bar

This panel allows to view data related to the current row. Is it possible to display 2 types of referenced data:

• detail - in the bottom table are displayed all rows related to current line of the upper grid. Relations, which are used, can be chosen in a drop-down list Detail.
• Master - in the bottom table is displayed one row related to selected cell in upper grid.
• master / detail works only if foreign keys are correctly defined.
• The Go to Icon - data that is displayed in the bottom table, will appear in upper table, so you can edit it and transitively view its references.

Tool Bar History

This panel allows to move in the history of links browsed by "Go To" command Reference panel. History is relative to the table selected in the connection tree. The reset command clears this history for the selected table.