[APP][PRO] MySQL-Client

[RonnyW]

Sure, just add a second Database device.

[Pat_M]

Perfect - Thanks! Jjust wanted to make sure!

[Pat_M]

Sorry, I tried reading the FAQ but I still don’t get it. How do I use the output from a flow that makes a select from a table? I created the SELECT flow, it works, but the second flow cannot get the result from the first flow?

Thanks!

[RonnyW]

Are you using standard or advanced flow?
Advanced flow is much easier because you can concatinate the cards.

[APP][PRO] MySQL-Client

With test version 0.0.11, flow tokens for Advanced Flows are added for the flow action “Execute SQL query”. Using these tokens, you can directly use the SQL result in your flow. With the new logic cards you canparse the reault JSON string and extract more than only the first field. Example: [grafik] This flow is: executing the SELECT statement, reading one line from the table printing the result JSON string to the timeline extracting line1, field “gas_meter” from the JSON printing this va…

[Pat_M]

Thanks @RonnyW - It turned out that Homey was a bit crazy when I tried this. I works great today!
And thank you for this app, it wouldn’t be possible to run my home and Homey without it - supergreat work!

Thanks!