ConditionAction Element (ADF)
Contains elements that describe a condition action for a subscription class event rule or scheduled rule.
Syntaxe
<EventRule>
...
<ConditionAction>
OR
<ScheduledRule>
...
<ConditionAction>
Element Characteristics
Characteristic | Description |
---|---|
Data type |
None. |
Default value |
None. |
Occurrence |
Occurs at most once per EventRule or ScheduledRule, which can contain either an ConditionAction or Action. |
Updates |
Can be modified, added, or deleted when updating the application. |
Element Relationships
Relationship | Elements |
---|---|
Parent element |
|
Child elements |
Notes
A condition action allows for flexible rules created by subscribers. ConditionAction elements contain elements that describe the input source and the query used to generate notifications from input and subscription data.
For more information about condition actions, see Définition des actions de condition.
Exemple
The following example shows how to define a condition action. The query in the Transact-SQL expression selects data from the MyAppSchema.FlightEventRule view, which contains data from the subscription class and from the MyAppSchema.WeatherEvents event view.
<ConditionAction>
<SqlLogin>[MyLowPrivLogin]</SqlLogin>
<SqlUser>[MyLowPrivUser]</SqlUser>
<InputName>WeatherEvents</InputName>
<InputSchema>MyAppSchema</InputSchema>
<SqlExpression>
INSERT INTO MyAppSchema.WeatherNotifications(SubscriberId,
DeviceName, SubscriberLocale, City, Forecast)
SELECT [Subscription.SubscriberId], [Subscription.DeviceName],
[Subscription.SubscriberLocale], [Input.City],
[Input.Forecast])
FROM MyAppSchema.FlightEventRule;
</SqlExpression>
</ConditionAction>
Voir aussi
Référence
Application Definition File Reference
Concepts
Instance Configuration File Reference
Autres ressources
Définition des actions de condition
Définition de règles d'abonnement