Skip to main content
Solved

How to filter the output from feature reader when id = specific no. From all tables that read

  • May 1, 2023
  • 2 replies
  • 80 views
gogopotter90
Contributor
Forum|alt.badge.img+14

Hello

i am reading many tables from oracle non spatial

tables name

Table_A

Table_B

Table_C

i have around 30 table

and I would like to get the Output from all tables when Id= 45

i am not sure ,how to write the condition in where clause to test it in all tables

and In case it did not find the id in any table so I will not get any output from this table .

But in case also ,no id as attribute name in any table so I get nothing better than error ,if it is possible .

Fme 2021

 

Best answer by nielsgerrits

Not having Oracle DB here so I can't test it, but I assume you can simply use the Where clause and enter something like

objectid = 5250

 For the FeatureReader the Where clause will work on all selected tables.

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

nielsgerrits
VIP
Forum|alt.badge.img+60
  • nielsgerritsVIP
  • 2937 replies
  • Best Answer
  • May 1, 2023

Not having Oracle DB here so I can't test it, but I assume you can simply use the Where clause and enter something like

objectid = 5250

 For the FeatureReader the Where clause will work on all selected tables.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
gogopotter90
Contributor
Forum|alt.badge.img+14
  • gogopotter90Contributor
  • Author
  • Contributor
  • 239 replies
  • May 1, 2023

Not having Oracle DB here so I can't test it, but I assume you can simply use the Where clause and enter something like

objectid = 5250

 For the FeatureReader the Where clause will work on all selected tables.

Thanks 

objectid = ‘5250‘

it works 

Community Stats

32,064
Posts
121,727
Replies
39,690
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.