Skip to main content

Hi.

Is it possible to execute dynamic SQL in the InlineQuerier ?

I tried something like: SELECT * FROM Merged WHERE @Value(“sql_where”)

but it doesn’t seem to work.

Are there not substitution done in the “SQL Query” window in InlineQuerier ?

Yes, I know it has to be SQLite syntax, and it is.

Cheers.

Hi ​@lifalin2016 Would you be willing to share a screenshot of your SQL Query Editor? 

I believe if the value is available on the the side bar, it should work. Like how I did here with a User Parameter.