I am following the guide on creating views as per this link
However, when I drag out one of the resources (different join types), and then release the mouse on the corresponding join column in the second table, nothing happens. Once you drag out the join type you get a little box as per below
When you drag that onto the column and release the mouse button, nothing happens.
Not sure what’s going on here, but the view editor is non functional like this.
Other questions:
I see no way to add column comments for columns exposed in a view. i.e . there is no description field per column which carries through to SQL (in this case Oracle) like
COMMENT ON COLUMN Column1 AS ‘This is Column One’
in the same was as it does for a table. The net effect of this is we cannot manage metadata on columns in views, the same as we do for tables.
Is there no way to alias tables in the view editor? To have every column referenced as
SCHEMANAME.TABLENAME.COLUMNNAME is just a bit “clunky”
The issue “View Editor join resources are not working” is fixed.
Please update the software to latest patch build (build 20200530ac or later for v16.1) to get the fix.
Details about update to latest patch can be found at
Please make sure you have pressed the “Update to latest patch” button on the left hand side of the dialog right after launching the update program
For “how to define column comment”. We will consider to support it in future release. You will be notified once it is being supported.
For “define column alias”. You can do via View Editor as following screenshot.
A table alias can be created by double clicking on the table name in the View Editors diagram, just replace the table name with the alias. It will then appear next to the table name and be defined and used in the generated view