[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