Skip to main content
Solved

Feature Reader Where Clause

  • January 16, 2025
  • 2 replies
  • 26 views
ingalla
Contributor
Forum|alt.badge.img+10

Hello

I have set up a feature reader, reading a geopackage and have also set up a user parameter requesting the GSS code from the user to find.

When i add “gsscode” = $(LOCALAUTHORITY) nothing is exited via the reader, however, if i remove the where clause from the reader and add a tester with gsscode = $(LOCALAUTHORITY) everything works as expected.

Please see images below, but any ideas what is wrong.  I dont mind having a tester, but would just like to remove it and use the WHERE Clause..

Regards

 

Andy

 

Feature Reader
 
Parameter
 

 

Tester

 

Best answer by liamfez

Try adding quotation marks around the parameter in the where clause, like this:
“gsscode” = “$(LOCALAUTHORITY)“

View original
Did this help you find an answer to your question?

2 replies

liamfez
Influencer
Forum|alt.badge.img+34
  • liamfezInfluencer
  • Influencer
  • Best Answer
  • January 16, 2025

Try adding quotation marks around the parameter in the where clause, like this:
“gsscode” = “$(LOCALAUTHORITY)“

not a bot
ebygomm
1 person upvoted this
  • ebygomm
    ebygomm
ingalla
Contributor
Forum|alt.badge.img+10
  • ingallaContributor
  • Author
  • Contributor
  • January 16, 2025

Thanks very much, worked perfect…

Safe - do you need to update the documentation for the feature reader to specify the double quotes…..

Reply


Helpful Members This Week

Community Stats

30,947
Posts
117,285
Replies
38,743
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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