Skip to main content
Question

Pass where clause to FeatureReader

  • November 4, 2019
  • 1 reply
  • 9 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)

1 reply

jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
  • 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)).

 

 


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