SqlExpression Element for Protocol/Fields/Field (ADF)
Specifies a valid Transact-SQL expression that provides the protocol field value.
Syntax
<NotificationClasses>
<NotificationClass>
...
<Protocols>
<Protocol>
...
<Fields>
<Field>
...
<SqlExpression>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string, between 0 and 4,000 characters in length. |
Default value |
None. |
Occurrence |
Optional once per Field element. |
Updates |
Can be modified, but not added or deleted, when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
A Transact-SQL expression is a combination of identifiers, values, and operators that the database engine can evaluate to get a result. You can use any expression that can be part of a SELECT statement. The terms of the expression can be any of the following:
- Constants.
- Calls to functions.
- The notification fields defined in the ADF (but not computed fields).
- The following built-in notification fields:
- SubscriberId
- DeviceName
- DeviceTypeName
- DeviceAddress
- SubscriberLocale
- DeliveryChannelName
For more information, see Expressions (Database Engine).
Enclose string constants in single quotation marks.
If a Field element does not include a SqlExpression element, it must include a FieldReference element.
Example
The following example shows a how to define a Transact-SQL expression that concatenates a string with a notification field. This could be used as a subject line for an e-mail message.
<SqlExpression>
'Stock Price Update for ' + StockSymbol
</SqlExpression>
See Also
Reference
Application Definition File Reference
Other Resources
Specifying the Delivery Protocol Name and Fields
Expressions (Database Engine)
Updating Instances and Applications