Question

Where clause of two differents feature types

  • 9 August 2016
  • 4 replies
  • 4 views

Userlevel 4
Badge +30

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

Userlevel 2
Badge +12

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.

Userlevel 4
Badge +30

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

 

 

Badge +9

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

Badge +16

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

Reply