[mapserver-users] Using FILTER with OGR and spatialite

[Andrea Peri]

Hi,
I resolve the question.

The right setting was

FILTER "WHERE FIELD1 = 'val-1' and (FIELD2 like '%idtpn%' )"

Regards,

A.


2015-03-14 16:05 GMT+01:00 Andrea Peri <aperi2007 at gmail.com>:
> Hi,
> I'm try-ing without success to set a filter in a spatialite db
> I'm not sure my setting are right.
>
> I'm using this settings:
>
>     CONNECTIONTYPE OGR
>     CONNECTION '/path-to-spatialite-db/spatialite.sqlite'
>     DATA 'table1'
>     FILTER "FIELD1 = 'val-1' and (FIELD2 like '%idtpn%' )"
>     FILTERITEM 'FIELD1'
>     VALIDATION
>       'idtpn' '^[a-zA-Z0-9\-_]+$'
>       'default_idtpn' '%'
>     END
>
> Because I'm see nothing in the map, but no error are reported in debug-log.
> I guess the setting are wrong.
> But I dont understand what is wrong.
>
> Many thx to everyone .
>
>
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------