FILTER working on PostGIS layers?

[Paul Ramsey]

Frankly, I did not even know there was a FILTERITEM until just now.
It just implies another conditional in mappostgis.c to check for  
FILTERITEM and write the SQL automatically using the contents of  
FILTER instead of just using FILTER verbatim.  Too many ways to do  
the same thing!

P

On Sep 13, 2005, at 7:28 AM, Bart van den Eijnden wrote:

> Thanks Paul, this is exactly what Fernando mentioned in his  
> previous e-mail about Mapserver WFS.
>
> It does make building applications more difficult ..... having  
> different strategies for local and db datastores ..... but anyway  
> there is a way.
>
> Best regards,
> Bart
>
> Bart van den Eijnden
> Syncera IT Solutions
> Postbus 270
> 2600 AG  DELFT
>
> tel.nr.: 015-7512436
> email: BEN at Syncera-ITSolutions.nl
>
>
>>>> Paul Ramsey <pramsey at REFRACTIONS.NET> 13-9-2005 16:24:51 >>>
>>>>
> If you drop your FILTERITEM and use just FILTER "identbv = 20050049"
> that will work...
>
> On 13-Sep-05, at 6:45 AM, Bart van den Eijnden wrote:
>
>
>> Follow-up on this.
>>
>> It seems that layer->filter.string only contains the FILTER value
>> and not the whole expression to be used in the where clause.
>>
>> sprintf(query_string_0_6, "DECLARE mycursor BINARY CURSOR FOR
>> SELECT %s from %s WHERE (%s) and (%s && setSRID( %s,%s) )",
>> columns_wanted, data_source, layer->filter.string, geom_column,
>> box3d, user_srid);
>>
>> Does this sound familiar to anyone?
>>
>> Best regards,
>> Bart
>>
>>
>> Bart van den Eijnden
>> Syncera IT Solutions
>> Postbus 270
>> 2600 AG  DELFT
>>
>> tel.nr.: 015-7512436
>> email: BEN at Syncera-ITSolutions.nl
>>
>>
>>
>>>>> Bart van den Eijnden <BEN at SYNCERA-ITSOLUTIONS.NL> 13-9-2005
>>>>> 13:26:44 >>>
>>>>>
>>>>>
>> Hi list,
>>
>> I am running into an issue using Mapscript 4.7 from a few weeks back.
>>
>> PostGIS layers work fine for map display and query, but as soon as
>> I try to highlight a feature using FILTERITEM and FILTER I get the
>> following error (so it seems the filteritem is not used when
>> building the WHERE clause, the column exists in the database and
>> has the right case):
>>
>> [13-Sep-2005 13:06:43] PHP Warning:  [MapServer Error]:
>> prepare_database(): Error executing POSTGIS DECLARE (the actual
>> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
>> identbv::text,asbinary(force_collection(force_2d
>> (the_geom)),'NDR'),OID::text from bouwvergunning.aanvraag WHERE
>> (20050049) and (the_geom && setSRID( 'BOX3D(114024.650480941
>> 503134.482620259,115117.267932596
>> 503806.862590517)'::BOX3D,find_srid
>> ('','bouwvergunning.aanvraag','the_geom') ))' <br><br>
>>
>> Postgresql reports the error as 'ERROR:  argument of AND must be
>> type boolean, not type integer ........
>>
>> This is my LAYER definition:
>>
>> LAYER
>>   NAME "bimas"
>>   METADATA
>>     wms_title "Bouwvergunningen"
>>   END
>>   STATUS OFF
>>   DEBUG ON
>>   FILTERITEM "identbv"
>>   FILTER "20050049"
>>   TYPE POINT
>>   CONNECTION "user=stragisweb password=synstragisweb
>> dbname=wormerland host=127.0.0.1"
>>   CONNECTIONTYPE postgis
>>   DATA "the_geom from bouwvergunning.aanvraag USING UNIQUE identbv"
>>   PROJECTION
>>     "init=epsg:28992"
>>   END
>>   MINSCALE 0
>>   MAXSCALE 10000
>>   CLASS
>>     NAME bouwlocaties
>>     STYLE
>>       COLOR 255 0 0
>>       SIZE 12
>>       SYMBOL "Bouwlocaties"
>>     END
>>   END
>>   TEMPLATE "blank.html"
>> END
>>
>> Thanks in advance. Is this fixed in CVS?
>>
>> Best regards,
>> Bart
>>
>> Bart van den Eijnden
>> Syncera IT Solutions
>> Postbus 270
>> 2600 AG  DELFT
>>
>> tel.nr.: 015-7512436
>> email: BEN at Syncera-ITSolutions.nl
>>
>>
>
>