LEXICON
User Guide
Database Views : Create Administrative Elements : Create a Database View
A Database View defines a table definition for how the element data is displayed. The data can be derived from a single element or multiple elements. Make sure that the correct element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select the required database element from the displayed list.
Refer to Database Views for further information.
Rows are present in the resulting Database View table for each element that has a particular element type (ELEL) and meets any defined criteria (ATTFILTER and EXPFILTER). The Attribute Filter element is used to define matching criteria.
Make sure that the correct element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select ATTFILTER: Attribute filter from the displayed list.
The Expression Filter element is used to define matching criteria, rows are present in the resulting Database View table for each element that has a particular element type (ELEL) and meets any defined criteria (ATTFILTER and EXPFILTER). Additionally if element match criteria cannot be expressed using attribute filters then it is possible to define an expression for evaluation. All EXPFILTER criteria must be met for a row to be present in the table.
Make sure that the correct element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select EXPFILTER: Expression filter from the displayed list.
Make sure that the correct element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select SRCELEMENT : Source element from the displayed list.
The ATTCOLUMN element defines the attribute columns displayed in the database view, the columns operate on the SRCELEMENT that contains them.
Make sure that the correct SRCELEMENT in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select ATTCOLUMN: Attribute column from the displayed list.
A EXPCOLUMN element defines a column in the database view is based on an expression result, by default these columns are read only.
Make sure that the correct element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select EXPCOLUMN : Expression Column from the displayed list.
Refer to Database Views for further information.
A CRERULES element defines the rules for the creation of the context element. If owned by a DBVW element, the rules define row element creation, if owned by a SCRELEMENT the rules define column element creation.
Make sure that the correct element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select CRERULES : Create rules from the displayed list.
Refer to Database Views for further information.
A SETATTRIBUTE element defines the setting specified attribute. Make sure that the correct CRERULES element in the Dictionary hierarchy is selected, right click and from the displayed menu select Create then select SETATTRIBUTE : Set attribute rule from the displayed list.
A SETPARAMETER element defines a parameter that can be used with create expressions. The parameter value can be defined with the use of an expression, if unset, the user is prompted for input.
Make sure that the correct CRERULES element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select SETPARAMETER : Set Parameter from the displayed list.
A SETSTATUS element assigns the status to newly created elements, make sure that the correct CRERULES element in the dictionary hierarchy is selected, right click and from the displayed menu select Create then select SETSTATUS : Set status rule from the displayed list.
