[Mapserver-users] SDE queries are different

[Paul Ramsey]

The same things applies for PostGIS and OracleSpatial FILTERs. It is 
counterintuitive, yes. But the FILTER in the spatial database layers is 
passed directly to the SQL generator which is making the db call, so it 
has to conform to SQL where-clause syntax. It gets even more confusing 
though, because the EXPRESSION statements in CLASSes remain the same 
even in db-backed layers. This is because once the feature set is 
retrieved, the rest of the processing is done by Mapserver itself. So we 
use Mapserver syntax in the EXPRESSIONs. Clear as mud... :)

Murray, Ross wrote:
> I have a javascript function that builds a string (from an Oracle database)
> that is used as a layer filter. For example, the script may produce
> 
> 	' [CODE] ' = ' somevalue '
> 
> which is passed to Mapserver as the value for map_somelayer_filter.
> This works fine, only so long as the underlying source is a shapefile. If
> the layer is an SDE layer I have to use
> 
> 	CODE = ' somevalue '
> 
> So I have to now test to see if the layer being queried is a SDE layer!
> 
> Has anyone else had this problem, i.e. is this a bug that should be
> reported?
> 
> 
>  <<Murray, Ross.vcf>> 


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_