Skip to main content
Question

where clause Reader Paramaters

  • February 7, 2014
  • 2 replies
  • 33 views

kalbert
Supporter
Forum|alt.badge.img+14
Hello,

 

I have an ESRI Geodatabase Reader using a WHERE clause (Parameters / Advanced / .. that works good.

 

Now I like to import Feature Types to perform the same query.

 

 

Unforunately the Where Clause needs the feature class name in the sub-query:

 

 

(ATTR1, ATTRDATE) IN (SELECT ATTR1, MAX(ATTRDATE) FROM SDE.FCNAME GROUP BY ATTR1)

 

 

So my question is: is there a way to set the where clause on the Feature Type level instead of the Reader level? Or is there a way to replace the feature class name with a variable/link that points to the appropriate Feature Type?

 

 

I appreciate any hint

 

klaus

2 replies

sigtill
Supporter
Forum|alt.badge.img+24
  • Supporter
  • February 9, 2014
A workaround might be to use a CREATOR and then a FEATUREREADER on that ESRI GDB. There you can specify the WHERE CLAUSE and have that reader only read that specific reader.

kalbert
Supporter
Forum|alt.badge.img+14
  • Author
  • Supporter
  • February 10, 2014
The FeatureReader seems to be a powerfull transformer. But I can't see a way to work with a customized WHERE CLAUSE for every feature type.  Or do I need to use multiple FeaturReaders?

 


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