Beta Release 1.9.10

Data Browser Improvements:

• Improved query generation for import/export views and for history, counters, links, totals, and folder path LOV.
• Improved support for DateTime and timestamp formatting and conversions
• Better joins descriptions for Import / Export forms in the Actions / Columns modal dialog.
• Improved navigation in the Actions / Show Query modal dialog. The view mode can be chosen in a tab-pane.
• Improved trigger generation for updatable views. Added a key lookup for composite keys with a file path.
• Faster installation and refresh of materialized views.
• Improved page load performance for home page and data browser.
• Improved progress bar display for scheduler jobs.
• Improved query generation for LOVs. Up to 4 levels of recursion are now resolved to build hierarchical and path descriptions.
• Manage Schema Tasks: The processes to add primary and natural keys have been improved.
  New buttons enable you to generate and download updatable views and UI-defaults.
• Improved refresh of report regions.
• Improved Dialog for Sorting and Grouping

New features:

• Alter Audit Info Columns
  In the Menu Settings / Edit History Settings you can now use the section 'Alter Audit Info Columns'
  to systematically add automatically managed adit info columns.
• When editing a form, early validation of entered data against the schema constraints and size limits via AJAX calls is now enabled.
• On the home page, the list of My Databases is now displayed when the application is using APEX authentication.
  This list informed you about the accessible schemas and their space usage and it enables you to switch the active schema by clicking on an entry.
  Multiple schemas have to be assigned to the APEX workspace and the supporting objects of the application have to be installed in those schemas
  to make them accessible for this application.

Sources:

• The PL/SQL packages weco_mail, weco_auth_mgr, and table app_preferences have been removed.
• The Pre-Installation-Validations for the privileges to execute dbms_lock, dbms_tcp, and dbms_smtp have been removed.
• in the custom authorization scheme, the package apex_mail is used instead of weco_mail.
• All of the PL/SQL and javascript source files that are installed by the application
  are listed in the sources directory of the git repository.
• Removed references to apex_ajax and instead use apex.server.process and plugin apex-plugin-clob-load.
• The demo time period is now 2 months.

Beta Release V 1.8.95

Data Browser Improvements:

• support for join options in the import views in the Actions/Columns dialog window.
• improved page load performance for home page and data browser.
• improved progress bar display for scheduler jobs.
• improved performance for the installation of supporting objects.
• improved performance for the refresh of the materialized views.
• improved query generation for LOVs. Up to 4 levels of recursion are now resolved to build hierarchical and path descriptions.
• bug fixes for Manage Schema Tasks.
• bug fixes for the refresh of report regions.
• bug fixes for report sorting via a click on the header when grouping is used.

Release V 1.8.86

Data Browser Improvements:

• improved form query generation for import/export forms.
• improved generation of join conditions for export views.
• better joins descriptions for import / Export forms in the Actions / Columns modal dialog.
• improved navigation in the Actions / Show Query modal dialog. The view mode can be chosen in a tab-pane.
• improved query generation for history, counter, links, totals, and folder path LOV.
• improved trigger generation for updatable views. add a key lookup for composite keys with a file path.
• improved installation sequence.
• faster installation of materialized views.

Sources:

• The PL/SQL packages weco_mail, weco_auth_mgr, and table app_preferences have been removed.
• The Pre-Installation-Validations for the privileges to execute dbms_lock, dbms_tcp, and dbms_smtp have been removed.
• in the custom authorization scheme the package apex_mail is used instead of weco_mail.
• all of the PL/SQL and javascript source files that are installed by the application are listed in the repository sources directory of the git repository.

Release V 1.8.77

New features
on page Manage Schema

1. Export UI Defaults
   Enables you to download a UI Defaults definition PL/SQL script file for tables of the current schema with additional attributes like optimal width, max length, format masks, and LOVs for references, Yes/No fields, and check constraints with IN-Lists.
   You can import this file with APEX to improve the default appearance of new forms on your tables.
   Example: https://github.com/dstrack/Schema_Data_Browser/blob/master/Examples/hr_uidefaults.sql

2. Export Updatable Views - download a PL/SQL Script with Create View statements for updatable views.
   The data browser displays this kind of view as report variant 'Import View'.
   In the Dialog Window 'Show query' you can choose 'Create View' to see the Script for the currently selected table. The setting for 'Import Controls' (Compare Case Insensitive, Search keys unique, Search keys unique) and UNIQUE CONSTRAINTS for the display values of you LOVs will control the generation of these views.
   The views will have INSTEAD OF INSERT OR UPDATE OR DELETE triggers that will manage the processing of DML statements on those views.
   You can import and execute this file with the APEX "SQL Workshop / Scripts" page to install this views. You may use this view as a data source in Interactive Grid.
   There you will be able to search in the display values based on LOV for references,
   and you will be able to edit data in each column.
   Example: https://github.com/dstrack/Schema_Data_Browser/blob/master/Examples/hr_imp_views.sql
   Bugfix: The generated query SQL code for rendering the form will call APEX_ESCAPE.HTML for character columns to prevent Cross-Site Scripting.
   The bug was discovered by Ved Prabhu from Bangalore, India, and then reported by Joel R. Kallman from Oracle.

Bugfix: The processing for the Button 'Duplicate Schema' on the Home page has been fixed.

UI-Appearance Option: Added a global control to show or hide Breadcrumbs below the page title. The control can be set by the online user via the Navigation Bar menu.

Data Browser: The style of the View Mode Navigation List has been changed to Navigation Tabs to improve the highlighting of the current View Mode.
The entries for 'Entity Relationship Diagram' and 'Springy Diagram' have been removed from the View Mode Navigation List and have been added to the 'Actions' menu.

Improved descriptions and help text and improved german translation of the App UI.

Release V 1.8.67

tuning, maintenance

Release V 1.8.64

The diagram renderer

• Besides the diagrams, there is now a control panel for all diagram parameters and node properties that can be adjusted with immediate visual feedback.

The diagram editor

• There is now an auto-focus button to give you an optimal view of a selected node.
• Many graphical and processing errors have been fixed.
• Support for touchpad
• Smart selection method

The Entity Relations, Object Dependencies, and the APEX Dynamic Actions diagrams

• have been improved to render and list all kinds of details.
• double click support to open the named object in the SQL Workshop or App Builder.

The Data Browser

• improved import processing
• improved navigation views and pagination

Beta Release V1.8.53

Schema & Data Browser V 1.8.53 Release Note

diagram editor

• improved display for selected node
• new method for smart selection: seleced, downstream, upstream, connected
• new actions for: Save as, Exempt Selected, Hide Selected, Show All, Pin Selected, Unpin Selected, Freeze / Lock All, Melt / Unlock All, Edit Diagram properties.
• new control panel for all diagram parameter: Zoom, Fontsize, min. Energy, max. Speed, Stiffness, Repulsion, Damping
• improved editor for node properties: Label, Shape, Color Names, Active - with life update.

schema diagrams

• faster automatic layout
• automatic smart selection: downstream for APEX dynamic actions, upstream for object dependences
• all methods, actions and controls of the diagram editor
• improved rendering of Object Dependences with options for Key Constraint, Check Constraint, Not Null Constraint
• improved rendering of APEX Dynamic Actions including Branches and Links and the option to follow a page link
• improved listing of details and display of object text.
• improved import processing

data browser

• improved page load performance
• improved rendering of nested reports with pagination.
• improved formating and processing for numbers and boolean fields.
• improved import processing
• new functions for import views: copy to collection, paste from collection

home page

• new functions to : Add a Schema, Remove Schema, Duplicate Schema, Upgrade supporting Objects

manage schema

• new wizards to : Add Serial Primary Keys, Add Natural Keys, Set Mandatory Key Columns

Beta Release V1.8.34

diagram editor

• improved display for selected node
• new method for smart selection: none, downstream, upstream, connected
• new actions for: Exempt Selected, Hide Selected, Show All, Pin / Fix, Unpin / Loosen, Freeze / Lock, Melt / Unlock, Edit Diagram properties.
• new control panel for all diagram parameters: Zoom, Font size, min. Energy, max. Speed, Stiffness, Repulsion, Damping
• improved editor for node properties: Label, Shape, Color Names, Active - with a life update.

schema diagrams

• faster automatic layout
• automatic smart selection: downstream for APEX dynamic actions, upstream for object dependencies
• all method, actions, and controls
• improved rendering of Object Dependencies and APEX Dynamic Actions.
• improved listing of details and display of object text.
• improved import processing

data browser

• improved page load performance
• improved rendering of nested reports with pagination.
• improved formatting and processing for numbers and boolean fields.

Beta Release V1.8.26

Improved performance for Diagrams and Data Browser.
Live controls for the diagram parameter.
New selection methods to highlight connected nodes.

Beta Release V1.8.24

Maintenance and tuning
Springy diagrams: tuning of math, memory usage and repeated calculations for applyCoulombsLaw, applyHookesLaw and render.
added functions zoom canvas, scale ZoomFactor.
Disabled accidental tracing in import processing and in the diagram rendering.