viewColumn

XML format for the viewColumn object

The viewColumn element is a child of the view object.

<schema schemaRevision="60" customerRevision=""
   <view name="rol_contct" id=289 >
      <viewColumn name="first_name" tableName="contact" columnName="first_name" .../>
   </view>
</schema>

Attribute Name

Required

Default

Description

name

Yes

 

Specifies the name of the column.

tableName

Yes

 

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

columnName

Yes

 

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

description

No

 

Description of the viewColumn and its purpose.

alias

No

 

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

order

No

 

The order of the view column within the view.

clarifyGenericFieldID

No

-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

view

join

Next

join

viewColumn