How to write the variable table in a query?

Queries and Resources
,
1

Hello, I want to do this query: SELECT id, message FROM {{table5.selectedRow.Usuario}} ORDER BY id DESC;) but it gives me an error, table5.selectedRow.User stores the following: "80916981d533d6de", and this is my mistake:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''80916981d533d6de' ORDER BY id DESC;)' at line 1

prueba
prueba1386×154 14.8 KB

How can I solve it?

2

Hi,

I think you have an extra ")" at the end of the query.
Also, usually I have to write something like table1.selectedRow.data.myProp

Hope this help

1 Like
3

+1 to the above! Though with the new table {{ table1.selectedRow.myProp }} should work without needing to add .data :tada: