Add a database of your MySQL compatible server as device to homey.
Use a flow card in the THEN part to execute a SQL query. Push sensor data to a database table if you want to log it.
Execute SELECT statements in the flow card to read data from your database.
React on the executed query in with a flow trigger and push the value to a virtual sensor.
Les mer ›
Flow-kort
Klikk på en enhet ovenfor for å kun vise relaterte Flow-kort.
Når …
Database
The SQL POST query (insert/update) was executed with id Query ID.
i
Triggers when the SQL POST query (insert/update) was executed and delivers the result as token. The execution can be filtered by Query ID.
Database
The SQL query was executed with id Query ID.
i
Triggers when the SQL query was executed and delivers the result as token. The execution can be filtered by Query ID.
Og …
Database
The result (as number) of SQL query SQL query with ID ID is ...
i
The result of the SQL query. Select a single numeric field to compare.
Database
The result (as number) of SQL query SQL query with ID ID is greater than ...
i
The result of the SQL query. Select a single numeric field to compare.
Database
The result (as text) of SQL query SQL query with ID ID is ...
i
The result of the SQL query. Select a single field to compare.
Database
The SQL query SQL query with ID ID was processed successfully
i
The flow continues when the SQL query is successfully executed.
Så …
Database
Executes the SQL query with ID ID: SQL query.
i
Use this action for SQL querys. An ID must be specified to evaluate the result. In the flow event, the response can be read via the Query ID. Use '[date-1d]', '[date-1m]' oder '[date-1y]' for calculation of a date based on the current date using a positive/negative difference in days, moths or years.
Advanced
Database
Executes the SQL query with ID ID: SQL query.
i
Use this action for SQL querys. An ID must be specified to evaluate the result. In the flow event, the response can be read via the Query ID. Use '[date-1d]', '[date-1m]' oder '[date-1y]' for calculation of a date based on the current date using a positive/negative difference in days, moths or years.
Nyheter
Versjon 1.0.4 — Workaround for wrong time conversion (UTC->local) in date variable '[date-1d]'.
Vis endringslogg