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 |
Hinweise
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.
.gif "ms146600.note(de-de,SQL.90).gif") Hinweis: |
|---|
| Make sure to back up your application database before updating the application. |
Beispiel
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>
Siehe auch
Verweis
Application Definition File Reference
Andere Ressourcen
Definieren des Benachrichtigungsschemas
Aktualisieren von Instanzen und Anwendungen