Skip to main content
Question

Running SQLExecutor with blank Parameters

  • May 28, 2018
  • 1 reply
  • 8 views
R

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • May 28, 2018

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

WHERE 1=1

Community Stats

32,086
Posts
121,845
Replies
39,727
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.