Navigate in the table datasets in logical views. Generate reports and forms. Edit, export, import, check, merge data.
• Via the view mode a logical preselection of columns can be chosen as the starting point and then further adjusted via the column menu. All aggregations for subordinate tables (counters, listing with links, totals) can be shown and hidden as required. Totals are automatically displayed in each parent relation as soon as a numerical data column has been marked as a summand.
• Sorting and Grouping is automatically applied for reports on tables with less the 10000 rows. Tables can be chosen from the relations tree or table list. By default, data is sorted by the label columns of the selected foreign key and by the natural key columns (label) of the main table. You can use the top pagination buttons to navigate in the current foreign key values and use the bottom pagination buttons to navigate in the current report or nested report.
• Filter table data with a General search field, that can be refined with a specific column and operator and values that can be chosen from a LOV. Save and reload your setting as a named report.

Create diagrams for current schema objects, code modules, APEX Dynamic Actions. Edit schema objects, show object text, follow page links and branches. Use Buttons or mouse scroll wheel to change the zoom level and font size. Use the method for smart selection: selected, downstream, upstream, connected. Actions for: Save as, Exempt Selected, Hide Selected, Show All, Pin Selected, Unpin Selected, Freeze / Lock All, Melt / Unlock All, Edit Diagram properties, Alter Schema Object, Show table data. Control panel for all diagram parameters: Zoom, Font size, min. Energy, max. Speed, Stiffness, Repulsion, Damping.

Review and manage the primary and natural key columns of the current schema. Use wizards to Add Serial Primary Keys, Add Natural Keys, Set Mandatory Key Columns.

View a summary and detailed history of the datasets.

Launch the Data Reporter application in a new window.

Create springy force diagrams for imported objects. The 'Springy Diagram' page displays an interactive graphic of nodes and their relations. When the mouse pointer is hovering over the background canvas, you can zoom into the graphic with the mouse scroll wheel and move the canvas with mouse drag and drop. When the mouse pointer is hovering over a node, you can zoom the font size of the nodes. You can click on a node, to display details in the right sidebar. You can choose a method for smart selection: selected, downstream, upstream, connected. Actions for: Exempt Selected, Hide Selected, Show All, Pin Selected, Unpin Selected, Freeze / Lock All, Melt / Unlock All, Edit Diagram properties. Control panel for the diagram parameter: Zoom, Font size, min. Energy, max. Speed, Stiffness, Repulsion, Damping. You can use an editor for the node properties: Label, Shape, Color Names, Active.

In 'Form View' reports all normal columns of the selected table are displayed. Serial primary key column and audit columns are hidden by default. In read-only mode, foreign key columns display the labels of the referenced rows. In edit mode, foreign key columns are LOV popup or select list fields with automatically composed labels. When available, additional functional columns can be displayed via the actions/columns menu option. In 'Form View', 'Navigation Counter' and 'Navigation Links' reports the height and width of large text blocks and images is constrained to keep the reports readable. When you click on images or document icon, a document preview modal dialog window is opened. In edit mode you can click on text cells with a pen icon to edit large text fields in an HTML-Editor modal dialog window.

'Navigation Counter' reports by default only display the natural key columns (labels), counters of references and totals of the active table. For each foreign key that references the current table, a column with count of references to a row is displayed. Depending on the setting of the 'Nested View' option, a click on a counter opens the references in a nested table view or on a separate report page. When available, additional functional columns can be displayed via the Actions/Columns menu option. When a number column of a child table is marked a 'Summand' via the Action/Alter Column Rules Dialog, totals for that columns will be displayed.

'Navigation Links' reports by default only display the natural key columns (labels) and totals for the current table. For each foreign key that references the current table, a column with a list of Links to child rows is displayed. A click on a Link opens the reference in a dialog page. When available, additional functional columns can be displayed via the actions/columns menu option. When a number column of a child table is marked a 'Summand' via the Action/Alter Column Rules Dialog, totals for that columns will be displayed.

'Raw Record' reports by default display all data columns of the selected table. Serial primary key column are hidden by default. Foreign key columns display the internal numeric values as stored in the database.

In 'Import View' reports all normal data columns of the selected table are displayed. Serial primary key column and audit columns are hidden by default. In read-only form, foreign key columns display the labels of the referenced rows, while in edit forms, foreign key columns are LOV popup or select list fields of individual label columns. In case of composite labels each component column is displayed as a separate column. The default report column list is suitable for data export and imports. The data import process can validate a convert CSV data files with columns that match the report columns layout. Then the lookup of foreign key references is automatically performed. Depending on the import setting, new lookup values for foreign keys are inserted in the referenced tables or error messages are produced when that is not permitted. When the natural key values (or chosen display columns values) of the imported data matches with existing rows in the current table, then the data is merged for that rows and the data is inserted in new rows when that keys don't match.

In 'Export View' reports by default all normal data columns of the current and the parent table are displayed by default. The serial primary key column and audit columns are hidden by default. Foreign key columns display the natural keys (labels) of the referenced rows. In the case of composite natural keys (labels) each component column is displayed as a separate column. In the modal dialog for Action/Columns Join Options are displayed. You can set the join options to systematically add columns of the referenced tables for each foreign key reference of the current table. After setting the 'All columns' Join option for a table, you can include further columns of the referenced table recursively up to the root of the keys. Independent of your settings, the report will produce one output row for each row in the current report table.

In 'History View' reports old versions of the table data can be displayed. The normal data columns and audit information is displayed by default. For foreign key columns, the composed label values are displayed. When the historic data differs from the current row values, that values are highlighted with different table cell background colors. Row changes have to be recorded in a change log to support the History Views. You have to enable the option 'Enable Change Log Support' in the Settings/Edit History Settings dialog page to enable this recording.

In 'Calendar' views data from the current table is displayed in Calendar regions. The natural keys (labels) are displayed in calendar sheets when a calendar start-date and optional end-date column has been registered for the current table.

In 'Tree View' views data from the current table is displayed in a Tree. The natural keys (labels) are displayed as tree nodes when a parent reference column has been registered for the current table. A parent reference is a foreign key reference to the same table with empty parent references for the root nodes.

The 'Entity Relationship Diagram' view displays an interactive graphic of table nodes and their relations. When the mouse pointer is hovering over the background canvas, you can zoom into the graphic with the mouse scroll wheel and move the canvas with mouse drag and drop. When the mouse pointer is hovering over a node, you can zoom the font size of the nodes. You can click on a table node, to open a default report of that table.