View Editor - Cannot create a join & other questions

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

Annotation 2020-05-04 123354

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:

  1. 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.

  1. 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”

Thanks

Hi SimonB,

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.

Best Regards,

Roy.

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

1 Like