Create an Action to Run a Query

About this task

This topic describes how to create an action to run a query. You can also create an action to:

Before you begin

Create a trigger based on an entity condition or a device condition.

Procedure

Access the event for which you want to create an action.
Select Run a Query.
The Run a Query section appears.

Enter or select values as described in the following table.

Field	Description
Query	Select the query that you want to run when the event is triggered. If the query that you have selected requires input values, the corresponding fields appear. If that happens, enter values in the available fields.
Scheduler	Select one of the following options: Take action only on initial trigger: Select this option if you want to run the query after switching from the state of not meeting the condition to meeting the condition. By default, this option is selected. For example, suppose you have created an action to run a query when the temperature recorded by a device exceeds 40 degrees Celsius. Suppose the temperature recorded by the device is as follows: 35, 38, 41, 45, 39, 42. In this scenario, the query is run when the temperature is 41 and 42. Take action on every trigger: Select this option if you want to run the query every time the event is triggered. For example, suppose you have created an action to run a query when the temperature recorded by a device exceeds 40 degrees Celsius. Suppose the temperature recorded by the device is as follows: 35, 38, 41, 45, 39, 42. In this scenario, the query is run when the temperature is 41, 45, and 42.

Field

Description

Query

Select the query that you want to run when the event is triggered. If the query that you have selected requires input values, the corresponding fields appear. If that happens, enter values in the available fields.

Scheduler

Select one of the following options:

Take action only on initial trigger: Select this option if you want to run the query after switching from the state of not meeting the condition to meeting the condition. By default, this option is selected. For example, suppose you have created an action to run a query when the temperature recorded by a device exceeds 40 degrees Celsius. Suppose the temperature recorded by the device is as follows: 35, 38, 41, 45, 39, 42. In this scenario, the query is run when the temperature is 41 and 42.
Take action on every trigger: Select this option if you want to run the query every time the event is triggered. For example, suppose you have created an action to run a query when the temperature recorded by a device exceeds 40 degrees Celsius. Suppose the temperature recorded by the device is as follows: 35, 38, 41, 45, 39, 42. In this scenario, the query is run when the temperature is 41, 45, and 42.

Select Save or Save and Exit.
The event template is created.

Results

When the event is triggered, the query that you have specified is run.