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.
 

 

Community Stats

32,030
Posts
121,641
Replies
39,655
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.