Skip to main content
Released

Enable Different 'WHERE ClAUSE' for Different Feature Types From the Same Reade

Related products:FME Form
  • February 18, 2016
  • 10 replies
  • 80 views

***Note from Migration:***

Original Title was: Enable Different 'WHERE ClAUSE' for Different Feature Types From the Same Reader(ArcSDE)


Enable Different 'WHERE ClAUSE' for Different Feature Types From the Same Reader To Avoid Creating Multiple Readers.

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.

10 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • February 18, 2016

This can be done:

Using the WHERE clause on the Reader will use the same WHERE clause for all feature types except for the feature type where a WHERE clause is entered.


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • February 18, 2016

Or if you want to apply that setting to a selected number of feature types, you can enter the setting with a feature type and use the "Apply to" button to select all feature types that you want to change.


  • Author
  • February 18, 2016

That is exaclty what I want, Different 'WHERE ClAUSE' for Different Feature Types.

But I can't seem to find the setting to define where clause for individual freature type.

I am using Arcsde reader.

Can you post a screenshot?


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • February 18, 2016

Sorry, but I am not an ESRI user.

But this is a screenshot of the ArcSDE Reader help:

'


  • Author
  • February 18, 2016

Yes, But that Where Clause is gonna be applied to all the Table in the TalbeList.

I want different Where Clause for different table without creating another reader.


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • February 18, 2016

Not sure about SDE, but this is where it is in the Oracle Reader:

'


  • Author
  • February 18, 2016

Aha, so it is a just a limitation of arcsde reader.

Ok, I give up, I will just create 2 reader instead.


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • February 18, 2016

As it seems to be not on the ArcSDE Reader feature types I will vote for this. If it exists on the Reader I do not see why it should not be able on the feature types.


fmelizard
Safer
Forum|alt.badge.img+22
  • Safer
  • February 21, 2016

Yes, there is a where clause for each feature type in the "Feature Type Properties -> Format Parameters" Tab


  • Author
  • February 22, 2016

'

Esri legacy ArcSDE Reader