Skip to main content
  • EN

Hi everyone,

I am stuck with the FeatureReader and I manage to read a table out of the database when I keep the WHERE clause empty, however when I fill in the WHERE clause based on the user choice of a choice list saved in a parameter "NAAM_BUURT" and I want to match it with the column also called "NAAMBUURT" I don't get an output. I just get schema data, while I also indicate that I want data features. Does anyone might know what I might be doing wrong? By th way I am using FME Desktop 2022.2.1.

 

afbeelding 

Hi joy,

 

I'm not 100% sure, but I think the WHERE-Clause is wrong. For my understanding you compare to strings. The first string is always "NAAM_BUURT" and the second is the configured parameter value, so it always compares 'NAAM_BUURT' = 'PARAMETER_VALUE' which will always return false. The first thing to validate this is by setting the parameter value to NAAM_BUURT that should return always true.

To fix this please remove the single quotes of the column name so that the resulting where-clause will be "NAAM_BUURT = '$(NAAM_BUURT)'" (without double quotes).

Enclose column names (for Oracle in any case, I'm not sure about other feature sources) in double quotes:

"NAAM_BUURT" = '$(NAAM_BUURT)'

 

Enclose column names (for Oracle in any case, I'm not sure about other feature sources) in double quotes:

"NAAM_BUURT" = '$(NAAM_BUURT)'

 

Thanks, it worked! I was wondering in case of values, do I also need quotes?

Reply


Community Stats

30,351
Posts
115,344
Replies
38,086
Members
Terms & ConditionsCookie settings
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.