|
|
|
The addSqlViewColumn element allows a new column to be added to a SQL view in the schema.
Example:
<addSqlViewColumn name="num_units" sqlView="my_new_SQL_view" datatype="Integer">
<description>This is the description of the SqlViewColumn.</description>
</addSqlViewColumn>
Required Attributes:
Attribute Name |
Description |
|---|---|
name |
Specifies the name of the column. |
sqlView |
Specifies the name of the SQL View on which this column should be added. |
dataType |
The data type of the column. Valid values are:
|
Optional Child Elements:
Element Name |
Default |
Description |
|---|---|---|
length |
0 |
For string columns, the length (in characters) of the column. This is required for string columns. The length can be increased, but cannot be decreased, as this could cause data loss. |
description |
|
Description of the column and its purpose. |
isSearchable |
false |
For Oracle database systems, indicates if this column should be searchable in a case-insensitive manner or not. |
isUserDefined |
true |
Indicates if this column has been defined by the customer. |
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. |
isCurrencyData |
false |
Indicates if this column holds monetary (currency) data. |
isPredefined |
false |
This attribute is not typically used. |
isMandatory |
false |
This attribute is not typically used. |
isDirect |
false |
This attribute is not typically used. |
isUserModified |
|
This attribute is not typically used. |
See Also |
Next |