Hi Jukka, after an update I try using
'default_idtpn' 'S%' and surprising me it work ! Meanwhile I try to define the default as a simply % 'default_idtpn' '%' but it don't work. So it need not only a text field but a text field starting with a character. Very rarely situation in our primarykey fields. :( Thx for support, Andrea. 2013/4/4 Rahkonen Jukka <[email protected]> > Hi Andrea, > > Could you make test by using something else than '9%' as variable default > value, for example 'K9%'? We have had troubles with selecting atrribute > values like "04.186.1.004" with SLD_BODY. We had to update the attributes > into "K04.186.1.004" for making filtering to work. Obviously Mapserver was > surprised in seeing two dots in a string that starts with a numeric > character. Your type mismatch error makes me wonder if there could be > something similar in your case. > > -Jukka Rahkonen- > > > ________________________________ > Andrea Peri wrote: > > > Thx Steve. > > > It work , > > > Just to do a step forward I try also to define as default a wildcard > > using this sintax > > > I try settings like this: > > > FILTER "WHERE ID_ING = '%idtpn%' " > > > metadata > > 'default_idtpn' '9%' > ... > > > But the mapserver return an error. > > > msOGRFileWhichShapes(): OGR error. SetAttributeFilter(ID_ING LIKE '9%') > failed on layer rt_speleologia.idingrotte.rt. > > Type mismatch or improper type of arguments to LIKE operator. > > > Reading the gdal/ogr documentation this sintax should be allowed in the > OGRSQL. I use gdal 1.9.1 and it seem to support the wildcard option. > > So perhaps this could be a real bug of gdal. > > I ask to gdal ML. > > > > 2013/4/4 Lime, Steve D (MNIT) <[email protected]<mailto: > [email protected]>> > Filter should look like: > > FILTER (ID_ING = '%idtpn%' ) > > If MapServer is to execute it, or: > > FILTER "WHERE ID_ING = '%idtpn%' " > > If OGR is to execute it. > > Steve > > From: [email protected]<mailto: > [email protected]> [mailto: > [email protected]<mailto: > [email protected]>] On Behalf Of Andrea Peri > Sent: Thursday, April 04, 2013 8:26 AM > To: [email protected]<mailto:[email protected] > > > Subject: [mapserver-users] How use the filteritem with a ogr spatialite db > > Hi, > > I'm try-ing to apply a filter to a spatialite db by ogr . > I try this > > CONNECTIONTYPE OGR > CONNECTION "/.../tematici.sqlite" > DATA "select > PK_UID,ID_ING,ID_GRO,NUMERO,NOME,CODCOM,COMUNE,ANNO,DATA_AGG,SCHEDA,RILIEVO,CGBEST,CGBNORD,GEOMETRY > from SPELEOLOGIA_INGRESSI_GROTTE" > FILTER "(ID_ING = '%idtpn%' )" > FILTERITEM 'ID_ING' > VALIDATION > 'idtpn' '^[a-zA-Z0-9\-_]+$' > END > ..... > METADATA > 'default_idtpn' '901707' > ..... > But it don't work. > There is some sample of filter usage with ogr format ? > > thx, > > > -- > ----------------- > Andrea Peri > . . . . . . . . . > qwerty àèìòù > ----------------- > > > > -- > ----------------- > Andrea Peri > . . . . . . . . . > qwerty àèìòù > ----------------- > -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù -----------------
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
