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'
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 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};
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?
You need to login to be able to post a reply.