addViewColumn

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

Example:

<addViewColumn name="case_reason" view="case_view" column="x_reason" table="case">
	<description>This is the description of the new view column.</description>
</addViewColumn>

Required Attributes:

Attribute Name

Description

name

Specifies the name of the view column.

view

Specifies the name of the view that this view column should be added to.

table

Specifies the name of the table that this view column comes from.

column

Specifies the name of the column on the table that this view column comes from.


Optional Child Elements:

Element Name

Default

Description

description

 

Description of the index and its purpose.

alias

 

If referencing a join that has an alias, the name of the alias.

clarifyGenericFieldID

-1

This data is used by Amdocs/Clarify applications to identify fields in different objects that are handled in a similar way. For example, a WIPbin contains different types of objects, such as cases and bugs. Certain fields in these objects (such as the ID number and title) are treated in the same way by the application and are assigned the same clarifyGenericFieldID.

Note: There is not an isUnique attribute. To indicate a viewColumn as unique, set the clarifyGenericFieldID to 3.

See Also

schemaScript

addColumn

addExclusiveRelationSet

addIndex

addJoin

addRelation

addSqlView

addSqlViewColumn

addTable

addView

updateColumn

updateIndex

updateJoin

updateRelation

updateTable

updateSchema

updateSqlView

updateSqlViewColumn

updateView

updateViewColumn

Next

updateColumn

addViewColumn