Database Views

The database views functionality provides the AVEVA E3D Design System Administrator the ability to map element data into tables (Database Views) for a user workflow or report. A Database View definition includes the criteria for selecting a set of elements from which the rows are constructed. Each column in the Database View is then either an attribute value or expression based on the row element or based on an element navigated to from the row element. In this way each row may represent data from multiple data elements and multiple database elements may be edited if a row of data is edited in a grid or via an import.

Database Views may be defined independently or grouped for use into Database View Sets. Database View Sets are visible to the end user and provide a means of organizing Database Views for related workflows.

Due to the standard restrictions on data access while in the Lexicon module it is not normally possible to display the results of the Database view definitions within the Lexicon module. For this reason it is advised that Database Views are developed as User Views (refer to Definition Sets) using the Database Views Editor in a module which has the appropriate data access. The Database View once developed can then be copied into the Dictionary database using the Database Views Editor.