Skip to main content
Question

Syntax for FeatureReader - Smallworld

J
Forum|alt.badge.img

I am having trouble getting the syntax right for the FeatureReader using Smallworld.

A small example: I would like to read all pipe segments that have certain status and a certain material (which could have been taken from an XML file, for example - here, for simplicity, I created the attributes with an AttributeCreator).

I have tried every variation with and without quotiation marks, but cannot get it to run. I am using FME 2013 (upgrading is not an option, as it's not in my power) and the SpatialBiz plugin to access Smallworld.

8 replies

itay
Supporter
Forum|alt.badge.img+16
  • itaySupporter
  • Supporter
  • May 9, 2017
@erik_jan, something you can help with?

 

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • May 11, 2017

The first question is: what SmallWorld reader are you using? The built in Smallworld (GE) reader or the Spatialbiz plugin for SmallWorld?

J
Forum|alt.badge.img
  • john_leo
  • Author
  • May 11, 2017
erik_jan wrote:

The first question is: what SmallWorld reader are you using? The built in Smallworld (GE) reader or the Spatialbiz plugin for SmallWorld?

Spatialbiz Plugin for Smallworld. I'm adding that to the question, should have been there in the first place.

 

 

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • May 11, 2017

Have you tried the WHERE clause: status = '@Value(status)' ?

That works for feature types in the Spatialbiz plugin reader.

J
Forum|alt.badge.img
  • john_leo
  • Author
  • May 11, 2017
erik_jan wrote:

Have you tried the WHERE clause: status = '@Value(status)' ?

That works for feature types in the Spatialbiz plugin reader.

I am at my home computer right now, so I can't confirm - but I am quite sure I did. Curiously, what did work is "where status='Existing' ", i.e. if I didn't use a variable.

 

Also what I was not able to do was a combination of two statements, such as "where status='Existing' and material='Steel'.

 

 

J
Forum|alt.badge.img
  • john_leo
  • Author
  • May 12, 2017
erik_jan wrote:

Have you tried the WHERE clause: status = '@Value(status)' ?

That works for feature types in the Spatialbiz plugin reader.

I fear this does not work: While the syntax seems to be accepted, the numbers are completely off (FME returns about 28000 entries, while SW states 92000 entries).

 

I fear this might be an SpatialBiz-Bug: I removed the where-clause altogether and the problem remained. I felt that was worth an own question: Bug in FeatureReader

 

 

erik_jan
Contributor
Forum|alt.badge.img+17
  • erik_janContributor
  • Contributor
  • May 12, 2017
john_leo wrote:
I fear this does not work: While the syntax seems to be accepted, the numbers are completely off (FME returns about 28000 entries, while SW states 92000 entries).

 

I fear this might be an SpatialBiz-Bug: I removed the where-clause altogether and the problem remained. I felt that was worth an own question: Bug in FeatureReader

 

 

Please supply the workspace and the log to support@spatialbiz.com and I or one of my colleagues will have a look.

 

 

J
Forum|alt.badge.img
  • john_leo
  • Author
  • May 12, 2017
erik_jan wrote:
Please supply the workspace and the log to support@spatialbiz.com and I or one of my colleagues will have a look.

 

 

Thanks! I have sent the workbench.

 

 

Reply


Helpful Members This Week

Community Stats

30,957
Posts
117,323
Replies
38,743
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.