<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18783">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Sry i forgot to write: All data have the same 
"datumzeit" = 2009-07-09 12:00:00</FONT></DIV>
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> 
  <A title=erguen.ay@gmx.de href="mailto:erguen.ay@gmx.de">Ergün Ayduran 
  (GMX)</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A 
  title=mapserver-users@lists.osgeo.org 
  href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</A> 
  </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, July 02, 2009 7:33 
  AM</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> [mapserver-users] Problem with 
  WFS Filter</DIV>
  <DIV><BR></DIV>
  <DIV><FONT size=2 face=Arial>Hi,</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial>i want to filter set a filter in a wfs 
  request:</FONT></DIV>
  <DIV><FONT size=2 face=Arial>I want to get all polygons, where ("von_pegel" 
  &gt;= 70 or "bis_pegel" &lt; 70) and datumzeit = 2009-07-09 
  12:00:00.</FONT></DIV>
  <DIV><FONT size=2 face=Arial>I tried it with the request:</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial><A 
  href="http://localhost/cgi-bin/mapserv.exe?map=C:/ms4w/Apache/htdocs/webgis/mapfile_wfs.map&amp;SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=GetFeature&amp;TYPENAME=flood&amp;Filter<Filter><And><Or><PropertyIsGreaterThanOrEqualTo><PropertyName>von_pegel</PropertyName><Literal>70</Literal></PropertyIsGreaterThanOrEqualTo><PropertyIsLessThan><PropertyName>bis_pegel</PropertyName><Literal>70</Literal></PropertyIsLessThan></Or><PropertyIsEqualTo><PropertyName>datumzeit</PropertyName><Literal>2009-07-09%2012:00:00</Literal></PropertyIsEqualTo></And></Filter">http://localhost/cgi-bin/mapserv.exe?map=C:/ms4w/Apache/htdocs/webgis/mapfile_wfs.map&amp;SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=GetFeature&amp;TYPENAME=flood&amp;Filter&lt;Filter&gt;&lt;And&gt;&lt;Or&gt;&lt;PropertyIsGreaterThanOrEqualTo&gt;&lt;PropertyName&gt;von_pegel&lt;/PropertyName&gt;&lt;Literal&gt;70&lt;/Literal&gt;&lt;/PropertyIsGreaterThanOrEqualTo&gt;&lt;PropertyIsLessThan&gt;&lt;PropertyName&gt;bis_pegel&lt;/PropertyName&gt;&lt;Literal&gt;70&lt;/Literal&gt;&lt;/PropertyIsLessThan&gt;&lt;/Or&gt;&lt;PropertyIsEqualTo&gt;&lt;PropertyName&gt;datumzeit&lt;/PropertyName&gt;&lt;Literal&gt;2009-07-09%2012:00:00&lt;/Literal&gt;&lt;/PropertyIsEqualTo&gt;&lt;/And&gt;&lt;/Filter</A>&gt;</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial>and with this request (is the same 
  request,without %20 in date)</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial><A 
  href="http://localhost/cgi-bin/mapserv.exe?map=C:/ms4w/Apache/htdocs/webgis/mapfile_wfs.map&amp;SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=GetFeature&amp;TYPENAME=flood&amp;Filter<Filter><And><Or><PropertyIsGreaterThanOrEqualTo><PropertyName>von_pegel</PropertyName><Literal>70</Literal></PropertyIsGreaterThanOrEqualTo><PropertyIsLessThan><PropertyName>bis_pegel</PropertyName><Literal>70</Literal></PropertyIsLessThan></Or><PropertyIsEqualTo><PropertyName>datumzeit</PropertyName><Literal>2009-07-09">http://localhost/cgi-bin/mapserv.exe?map=C:/ms4w/Apache/htdocs/webgis/mapfile_wfs.map&amp;SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=GetFeature&amp;TYPENAME=flood&amp;Filter&lt;Filter&gt;&lt;And&gt;&lt;Or&gt;&lt;PropertyIsGreaterThanOrEqualTo&gt;&lt;PropertyName&gt;von_pegel&lt;/PropertyName&gt;&lt;Literal&gt;70&lt;/Literal&gt;&lt;/PropertyIsGreaterThanOrEqualTo&gt;&lt;PropertyIsLessThan&gt;&lt;PropertyName&gt;bis_pegel&lt;/PropertyName&gt;&lt;Literal&gt;70&lt;/Literal&gt;&lt;/PropertyIsLessThan&gt;&lt;/Or&gt;&lt;PropertyIsEqualTo&gt;&lt;PropertyName&gt;datumzeit&lt;/PropertyName&gt;&lt;Literal&gt;2009-07-09</A> 
  12:00:00&lt;/Literal&gt;&lt;/PropertyIsEqualTo&gt;&lt;/And&gt;&lt;/Filter&gt;</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial>Both requests response me only all 
  polygons.</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial>Example: </FONT></DIV>
  <DIV><FONT size=2 face=Arial>(1)&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 0 - 
  50</FONT></DIV>
  <DIV><FONT size=2 face=Arial>(2)&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 50 - 
  100</FONT></DIV>
  <DIV><FONT size=2 
  face=Arial>(3)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 - 
  150</FONT></DIV>
  <DIV><FONT size=2 face=Arial>(4)&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 150 - 
  200</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial>Setting the filter should response only (2), (3) 
  and (4)</FONT></DIV>
  <DIV><FONT size=2 face=Arial>Plz, can anyone tell me, what is wrong in my 
  filter.</FONT></DIV>
  <DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
  <DIV><FONT size=2 face=Arial>EA</FONT></DIV>
  <P>
  <HR>

  <P></P>_______________________________________________<BR>mapserver-users 
  mailing 
  list<BR>mapserver-users@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/mapserver-users<BR></BLOCKQUOTE></BODY></HTML>