What would be a work around to filter the features in the FFS reader, similar to other data readers that have the WHERE Clause parameter?
Question
FME Feature Store (FFS) has no WHERE Clause, workaround?
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.
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.
+12- Contributor
No.. this approach I want to exclude, I have a big FFS file( =long time for reading), that I don't want to read its whole content in order to pick certain records .
Hi,
The query functionality like "WHERE Clause" seems to be available only in a dataset which will be accessed from the reader via middle ware having a query mechanism (typically DBMS: database management system).
I don't think FFS has such a mechanism, unfortunately.
Takashi
+22- Contributor
Hi, I imagine you create the ffs file yourself, since it is an FME format. Why not create/prepare different ffs files, with the right TestFilters? Best regards, Jelle
+21- Safer
Other the using the features type to read parameter and the suggestions here, you are out of luck....