filter with OR and SpatialFilter

[nick_xu]

my code does a query based on filter and within the goemetry selected.

If the filter is simple like "TYPE=1", then it works fine, but when Filter contains OR, then it will return all features and ignore the spatial filter.

queryOptions.SetFilter("TYPE=1 OR TYPE = 2")

queryOptions.SetSpatialFilter(geometryField, selectionPoly,

MgFeatureSpatialOperations.Intersects);

MgFeatureReader fr = this._featureService.SelectFeatures((newMgResourceIdentifier(themeLayer.FeatureSourceId)), themeLayer.GetFeatureClassName(), queryOptions);

the feature provider is autodesk.oracle.

I did another test using sdf based layer and it returned features inside selected geometry on both filter with or without "OR" situations.

[jackie.ng]

I think it may be the same problem as this one:

http://trac.osgeo.org/fdo/ticket/864

Basically, the FDO provider is not properly wrapping () around the translated non-spatial filter resulting in incorrect operator precedence when combined with a spatial filter.

- Jackie