ComputedFields Element (ADF)
Provides a location for all of the computed notification field definitions for one notification class.
Sintaxis
<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 |
Notas
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.
[!NOTA] Make sure to back up your application database before updating the application.
Ejemplo
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>
Vea también
Referencia
Application Definition File Reference
Otros recursos
Definir el esquema de notificación
Actualizar instancias y aplicaciones