Skip to main content
Question

Pass where clause to FeatureReader

  • November 4, 2019
  • 1 reply
  • 14 views
sunsilk11
Contributor
Forum|alt.badge.img+6

Hi I have used SQLCreator to query multiple tables in SDE using various criteria and end up with a list of IDs.

I would now like to pass the list of IDs to a FeatureReader, so that I can reduce the number of records to read.

Any idea how I can build the whereclause to pass to the featurereader? I would like to build single sql as

ID=any(1,2,3,4...2000)

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

jdh
Contributor
Forum|alt.badge.img+37
  • jdhContributor
  • Contributor
  • 2002 replies
  • November 4, 2019

A combination of ListConcatenator and AttributeCreator should do the trick.

 

 

the AttributeCreator would have something along the lines of ID=any(@Value(_concatenated)).

 

 

Community Stats

32,079
Posts
121,810
Replies
39,714
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.