Target a database view in queries and other database views

Database views can be used as searchable data set in native SQL queries. Use of database views in Alfabet query language is not supported.

When data from a database view is included into the SELECT statement of a native SQL query, the call to the database view causes the query of the database view to be executed with the filter conditions defined in the native SQL query that calls the database view data.

The column names in database views based on an Alfabet query usually contain white spaces and might also contain special characters. Column names should be written into the select statement of the native SQL query targeting the database view in inverted commas.

A native SQL query defined for creating a database view can also call data from other database views. If you create a database view that uses data from another database view, you must make sure that the configuration object for that database view is located beneath the configuration object for the called database view in the Database Views node of the Meta-Model explorer in Alfabet Expand.