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:
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.
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.
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
from your supplied image I see you are using the writer where clause and not the writer feature type as described by @ciarab.