Skip to main content
Solved

feature reader where clause

  • June 25, 2020
  • 2 replies
  • 262 views

boubcher
Contributor
Forum|alt.badge.img+11
Hello There

I am reading a large file GDB , using the FeatureReader , but the where clause is disabled, when I user normal reader this option is enabled ?? andy reason for that

 

the goal is to increase the performance when reading the features

Thanks

 

Best answer by markatsafe

@boubcher The Esri Geodatabase (File Geodb Open API) reader only supports WHERE on Feature Types, not at the reader level. Most other database readers (including Esri Geodatabase (File Geodb)) support a WHERE at both the reader level (not that useful) and on the Feature Types.

The FeatureReader currently only supports the WHERE at the reader level, not on individual feature types. Hence WHERE isn't available for the Esri Geodatabase (File Geodb Open API) reader in the FeatureReader but it is for Esri Geodatabase (File Geodb) reader. For most other databases the FeatureReader WHERE applies to all feature types that are read (which isn't that useful).

The plan is to update the FeatureReader to support all the reader feature type parameters.

 

 

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.

2 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • June 25, 2020

Hi @boubcher

There is a Idea to implement this Here .

 

Thanks,

Danilo


Forum|alt.badge.img+2
  • 1891 replies
  • Best Answer
  • June 25, 2020

@boubcher The Esri Geodatabase (File Geodb Open API) reader only supports WHERE on Feature Types, not at the reader level. Most other database readers (including Esri Geodatabase (File Geodb)) support a WHERE at both the reader level (not that useful) and on the Feature Types.

The FeatureReader currently only supports the WHERE at the reader level, not on individual feature types. Hence WHERE isn't available for the Esri Geodatabase (File Geodb Open API) reader in the FeatureReader but it is for Esri Geodatabase (File Geodb) reader. For most other databases the FeatureReader WHERE applies to all feature types that are read (which isn't that useful).

The plan is to update the FeatureReader to support all the reader feature type parameters.