[Featureserver] Equivalent of fileter encoding

Yves Moisan yves.moisan at boreal-is.com
Fri Jun 12 15:30:49 EDT 2009


Hi list,

For the record, I have made some tests comparing PgAdmin filters and FS
filters.  MyField is a string and total number of records is 3100.

PgAdmin

1) MyField >='ABCD-0135' AND MyField <='ABCD-0184'  : 50 records
2) MyField ILIKE 'ABCD%' : 79 records
3) MyField LIKE 'ABCD-014%' : 10 records

FS :

1)
http://MyHost:8080/MyFSLayer?queryable=MyField&MyField__gte=ABCD-0135&MyField__lte=ABCD-0184 : NO FILTERING
2) http://MyHost:8080/MyFSLayer?queryable=MyField&MyField__ilike=ABCD% :
79 records OK
3)
http://MyHost:8080/MyFSLayer?queryable=MyField&MyField__ilike=ABCD-014% : 10 records OK

Conclusion : ILIKE works but not an interval type of query.

Cheers,

Yves




More information about the Featureserver mailing list