ComputedFields Element (ADF)
Provides a location for all of the computed notification field definitions for one notification class.
Syntax
<NotificationClasses>
<NotificationClass>
...
<Schema>
...
<ComputedFields>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
None. |
Default value |
None. |
Occurrence |
Optional once per /NotificationClass/Schema node. |
Updates |
Can be added and deleted when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
Remarks
If you add or delete the ComputedFields element, SQL Server deletes and recreates the corresponding notification class when you update the application. This includes dropping and re-creating the SQL Server tables used by this notification class.
Note
Make sure to back up your application database before updating the application.
Example
The following example shows a populated ComputedFields node. The computed fields, MaxChange and AvgChange, show the maximum growth and the average growth of the stocks in a chronicle table.
<ComputedFields>
<ComputedField>
<FieldName>StockPrice</FieldName>
<SqlExpression>CONVERT(NVARCHAR(10), StockPrice, 1)
</SqlExpression>
</ComputedField>
</ComputedFields>
See Also
Reference
Application Definition File Reference
Other Resources
Defining the Notification Schema
Updating Instances and Applications