Hi, If possible, test with some data that we others can also use easily. Trying with another dataset removes also the possibility that there is something special in your own data. In this case the famous topp:states feels suitable.
http://localhost:8080/geoserver/wfs?service=wfs&version=1.1.0&request=GetFeature&typeName=topp:states&cql_filter=WATER_KM>6000 Result=OK, have a next try with 2000+4000 instead of 6000 http://localhost:8080/geoserver/wfs?service=wfs&version=1.1.0&request=GetFeature&typeName=topp:states&propertyname=STATE_NAME,WATER_KM&cql_filter=WATER_KM>(2000.00+4000.00) Result=Error, let's change '+' into '%2B' http://localhost:8080/geoserver/wfs?service=wfs&version=1.1.0&request=GetFeature&typeName=topp:states&propertyname=STATE_NAME,WATER_KM&cql_filter=WATER_KM>(2000.00%2B4000.00) Result=OK, improve formula into (2000+4000)/2 http://localhost:8080/geoserver/wfs?service=wfs&version=1.1.0&request=GetFeature&typeName=topp:states&propertyname=STATE_NAME,WATER_KM&cql_filter=WATER_KM>(2000.00%2B4000.00)/2 Result=OK Perhaps the reason for the remaining trouble is the extra space characters in your formula: '2000 + 4000' instead of '2000+4000'. -Jukka Rahkonen- ________________________________ venky wrote: Hi Mauro, Thanks for your reply. I tried as per your instruction but got the same result. plz the generated url Query is: Area > (41.9696 + 42.9826) / 2 http://localhost:8080/geoserver/wfs?service=wfs&version=1.1.0&request=GetFeature&typeName=Plymouth_Buildings&cql_filter=Area%20%3E%20(41.9696%20+%2B+%2042.9826)%20/%202 Is there anything I did wrongly? Kindly help me plz On Sat, Dec 28, 2013 at 1:59 PM, Mauro Bartolomeoli <[email protected]<mailto:[email protected]>> wrote: Hi venky, 2013/12/24 venky <[email protected]<mailto:[email protected]>> Hi Mauro, All is fine now. But below thing is not returning correct result. Is there anything wrong in that? Area ------- 41.9696 42.9826 43.0137 43.6441 46.8394 46.9315 47.2082 781.198 Area > ('41.9696' + '42.9826') / 2 Its filtered out only 1 feature,Its Area 781.198 Please, try removing quotes around the numeric values in your filter. Quotes are used for string literal values, and I presume that using sum with quoted strings you get concatenation of strings and not arithmetic sum. Your filter should be: Area > (41.9696 + 42.9826) / 2 Regards, Mauro Bartolomeoli -- == GeoSolutions will be closed for Christmas Holidays from 23/12/2013 to 06/01/2014 == Dott. Mauro Bartolomeoli @mauro_bart Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
