Forums

Is it possible to set up the "Where" function in a Read Data operation to read the Field selected elsewhere via a Dropdown?
​
Example -
Table Field Name: {data:area}
Condition: =
Value: Y
​
FYI - No the above entry does not work but returns the following error1054
Unknown column 'Data.{data:area}' in 'where clause'

Hi
​
I Don't think...
But may be it's possible with SQL Datas.. I'll try this afternoon...

I confirm:
​
It doesn't work with Read Data Action, but it works with SQL Datas Action:
​
Select * from 'mytable' WHERE {data:field} = {var:value};

Thank you for that, where do I get the SQL Datas Action?