addView

The addView element allows a new view to be added to the schema.

The example below is a typical view that joins two tables and has a view column for each table.

Example:

<addView name="my_new_view" id="3001">
	<description>This is the description of the new view.</description>
</addView>

<addJoin kind="Inner" view="my_new_view" relation="case_reporter2contact" table="case" />
<addViewColumn name="case_reason" view="my_new_view" column="objid" table="contact" />
<addViewColumn name="case_objid" view="my_new_view" column="objid" table="case" />

Required Attributes:

Attribute Name

Description

name

Specifies the name of the view. This must be a unique name amongst all tables and views.

id

Specifies the id number of the view. This must be a unique id amongst all tables and views. The customer range for IDs is 430-511 and 2000-4999.


Optional Child Elements:

Element Name

Default

Description

description

 

Description of the view and its purpose.

groupName

 

Specifies the name of the application module that the view is used by.

See Also

schemaScript

addColumn

addExclusiveRelationSet

addIndex

addJoin

addRelation

addSqlView

addSqlViewColumn

addTable

addViewColumn

updateColumn

updateIndex

updateJoin

updateRelation

updateTable

updateSchema

updateSqlView

updateSqlViewColumn

updateView

updateViewColumn

Next

addViewColumn

addView