...
Tab | Field | Description | |
---|---|---|---|
General | Name | Enter a name for the unit. It must start with a letter, and cannot contain spaces. Only letters, numbers, and underscores are allowed. | |
Description | Enter a description detailing the scope of the unit. | ||
Check DB configuration | Whether to check the connection to the DB when the unit is configured. This actually tries to connect to the given DB with provided parameters. | ||
Poll wait time | Time (in milliseconds) to wait between query iterations when the unit is in a data stall in order to avoid closing the query. | ||
Max loops | The maximum number of iterations of the query. | ||
Query | The Devo query to be performed, in LINQ format. This query can include parameters (defined in the 'parameters' field), that will be filled with the corresponding input event field. | ||
Start time | You can specify a start time if you wish to test the query without input events. The unit will start sending data from that time included. | ||
End time | You can specify an end time if you wish to test the query without input events. The unit will stop sending data from this time (excluded). | ||
Parameters | A list of field names to be used as parameters in the query, evaluated in order. Click the plus icon to add. You can collapse and expand the parameters using the iconicons, reorder using the arrows, or delete using the X icon. | ||
Fields on | When defined, this is the name of the output event field with a list of column names. | ||
Map on | When defined, this is the name of the output event field if you wish to map from column names to values. | ||
Ensure all data | If this is set, the query will wait to obtain all data before beginning. | ||
Columns | Event field | The name of an input event field containing a list of (name, type) pairs. | |
Fields | Click the plus icon to add name-type pairs. You can collapse and expand the pairs using the iconicons, reorder using the arrows, or delete using the X icon. You can also reorder the fields using drag and drop. | ||
Name | The name of an output event field where the query result will be inserted. | ||
Type | The expected type for the query result (java class qualified name). |
...
Info |
---|
After saving and starting the Flow, you must click the red button of the Tick unit to begin sending events. |
📁 Download this example
You can try this flow by downloading the following JSON file and uploading it to your domain using the Import option:
...