Database Views

The Database Views functionality available in the Configuration module provides the administrator with the ability to map element data into sets of related tables (Database View Sets). The database view sets are populated with rows that exist in a table for each element that meets specified criteria. The columns are derived from attributes, PML 1 or XPath1.0 expressions. Attributes and expressions for the columns are specified from the elements defined in the view definition (that is from multiple elements not just the row element).

Database Views are managed in Definition Sets, these include:

• Element View - Database views defined automatically to represent the database hierarchy.

• Project Views - Database views defined in the dictionary data bases for a project.

• User Views - Database views defined as a file in the users project settings.

It is advised to create Database Views as User Views with the Database Views Editor in the relevant module.

If the editor is not available it can be added with the customization command Aveva.Core.Database View. The customization command allows the opportunity to test the view as a user view with full data access.

Once a view is stable, it is easily copied with the editor from the User Views to the Project Views which adds it to the Dictionary database definitions.