Skip to main content
Question

Where clause of two differents feature types


danilo_fme
Evangelist
Forum|alt.badge.img+45

Hello Users,

I use the Reader Smallworld 4 and in my just one connexion on this Database i have two diferents features types.

I would like use a Where clause parameters to filter dates but with two conditions:

Condition 1 to feature type [Electricity] cable where Known_as = "Upper Milton Road LV"

 

Condition 2 to feature type [Gis] min_road_centre_line where Road_type = "A-Road"

Its not working when i use the Where Clause for both tables:

 

4 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • August 9, 2016

Does this Reader have a WHERE clause on the feature type?

That should be the one to use in this case.

I know the Spatialbiz (SBS) plugin reader for Smallworld does.


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Author
  • Evangelist
  • August 9, 2016
erik_jan wrote:

Does this Reader have a WHERE clause on the feature type?

That should be the one to use in this case.

I know the Spatialbiz (SBS) plugin reader for Smallworld does.

Yes has just a where Clause for conexion

 

 


ciarab
Contributor
Forum|alt.badge.img+9
  • Contributor
  • August 9, 2016

You could use the where clause for each feature type in the "Feature Type Properties -> Format Parameters" Tab and set the individual where clause for each feature type here rather than from the navigator. That way it will set the correct where clause for each feature type


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • August 10, 2016

from your supplied image I see you are using the writer where clause and not the writer feature type as described by @ciarab.


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