Dear Sirs
I’m trying to read all data from a table. I want to be able to select the table from a different component, by changing a parameter
I have made the following query:
SELECT {analyse}.*
FROM {analyse}
This works in the testing tab when I execute the query, with the analyse parameter SAMPLES. When using the Named query in a view I have to use “SAMPLES” with quotes to work.
but when try to use a binding to a params property I cant find a way to make it work. I would assume this should work: “{view.params.analyse}”
searching earlier topics I found that the MySQL db should have ANSI_QUOTES activated, but I don’t have admin access to the database