FeatureReader doesn't read from database with WHERE CLAUSE

Question

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.

geomancer · Accepted Answer

Enclosecolumnnames(forOracleinanycase,I'mnotsureaboutotherfeaturesources)indoublequotes:"NAAM_BUURT"='$(NAAM_BUURT)'

geobroetchen · Answer

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).

FeatureReader doesn't read from database with WHERE CLAUSE

3 replies

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded