Skip to main content
  • EN

Hi,

I have an SQLExecutor that uses some Public Parameters in the WHERE condition. If the user leaves the Parameter blank then the query look for blank "" fields. How can I dynamically control what goes into the WHERE condition, so when the parameter is blank we exclude that condition?

Thanks

The easiest solution may be to test for a blank where-statement and replace it with something like

WHERE 1=1

Community Stats

31,949
Posts
121,334
Replies
39,562
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.