Skip to main content
Question

Where clause of two differents feature types

  • August 9, 2016
  • 4 replies
  • 51 views

danilo_fme
Celebrity
Forum|alt.badge.img+52

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:

 

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.

4 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • 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
Celebrity
Forum|alt.badge.img+52
  • Author
  • Celebrity
  • 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.

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+18
  • 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.