Skip to main content
Solved

How can a user enter a field value which will be used in an SQL query in the server schema?

  • September 29, 2014
  • 1 reply
  • 6 views
K
Forum|alt.badge.img
I would like to know how to do the following operation with FME Server:

 

 

I have an Oracle table from which I want to read some records with a given field value. I want to use an Oracle Spatial Reader with SQL query. I want to implement it with FME Server, and I want the user to enter the field value, which is used in the SQL query. 

 

An example: At the Oracle Spatial table there is a field called "selector". I would like to create a schema with an Oracle reader with an SQL query.

 

 

Select * from table_name

 

Where selector = XXX

 

XXX=is the value the user enter in order to activate the server schema,

 

Thanks.

Best answer by dcam

First thing to do is create a published parameter called “selector_value’:

 

 

When you run your workspace on the FMEServer, you can set it up so your user will be prompted to enter a value for the selector_value.

 

 

In your reader where statement set it up like below so the statement uses the parameter value:

 

Selector = ‘$(selector_value)’

 

 

Then that should read only the features with the selector_value.
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

1 reply

D
Forum|alt.badge.img
  • dcam
  • Best Answer
  • September 29, 2014
First thing to do is create a published parameter called “selector_value’:

 

 

When you run your workspace on the FMEServer, you can set it up so your user will be prompted to enter a value for the selector_value.

 

 

In your reader where statement set it up like below so the statement uses the parameter value:

 

Selector = ‘$(selector_value)’

 

 

Then that should read only the features with the selector_value.

Helpful Members This Week

Community Stats

31,074
Posts
117,804
Replies
38,834
Members

Latest FME

Terms & ConditionsCookie settings

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
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.