Question

Pass where clause to FeatureReader

  • 4 November 2019
  • 1 reply
  • 3 views
sunsilk11
Rank
Badge +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
Rank
Badge +22

A combination of ListConcatenator and AttributeCreator should do the trick.

 

 

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

 

 

Reply


Community Stats

28,669
Posts
109,357
Replies
36,531
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.