[mapserver-users] WFS Expression and Dates

[Joaquín Rodriguez-Guerra Urcelay]

Hi list,

I have been trying to find how to use the LAYER FILTER option to specify the features of the dataset that are to be included in the layer, with dates.

Feature members in my layer are like this:

<gml:featureMember>
      <ms:my_layer fid="my_layer.1">
        <gml:boundedBy>
        	<gml:Box srsName="EPSG:4326">
        		<gml:coordinates>-15.678700,26.440000 -13.306000,28.555500</gml:coordinates>
        	</gml:Box>
        </gml:boundedBy>
        <ms:msGeometry>
        <gml:Polygon srsName="EPSG:4326">
          <gml:outerBoundaryIs>
            <gml:LinearRing>
              <gml:coordinates>-15.309400,28.555500 -13.306000,28.209400 -13.705900,26.440000 -15.678700,26.780200 -15.309400,28.555500 </gml:coordinates>
            </gml:LinearRing>
          </gml:outerBoundaryIs>
        </gml:Polygon>
        </ms:msGeometry>
        <ms:id>1</ms:id>
        <ms:coordsystemc>WGS84</ms:coordsystemc>
        <ms:sensor>ERS</ms:sensor>
        <ms:starttime>2010/02/14  2:08:00</ms:starttime>
        <ms:resolution>2</ms:resolution>
        <ms:polygon_area>POLYGON((-15.3094 28.5555, -13.3060 28.2094, -13.7059 26.4400, -15.6787 26.7802, -15.3094 28.5555))</ms:polygon_area>
      </ms:my_layer>
    </gml:featureMember>

And the folllowing filter expresions are working ok in my map file:

FILTER ([resolution]==2)
FILTER ('[sensor]'='ERS')

But I cant make work the temporal filter expresion, I have tried almost everything

FILTER (`[starttime]` < `2010-02-15`)  (http://osdir.com/ml/mapserver-users-gis/2007-10/msg00519.html) ---

and the closes I got to get it working it is with string comparisson:

('[starttime]'<'2010/2/15 00:00')

But I wonder if anyone here knows the rigth format for temporal expressions.

Thanks!

Regards,

Joaquín



______________________
This message including any attachments may contain confidential 
information, according to our Information Security Management System,
 and intended solely for a specific individual to whom they are addressed.
 Any unauthorised copy, disclosure or distribution of this message
 is strictly forbidden. If you have received this transmission in error,
 please notify the sender immediately and delete it.

______________________
Este mensaje, y en su caso, cualquier fichero anexo al mismo,
 puede contener informacion clasificada por su emisor como confidencial
 en el marco de su Sistema de Gestion de Seguridad de la 
Informacion siendo para uso exclusivo del destinatario, quedando 
prohibida su divulgacion copia o distribucion a terceros sin la 
autorizacion expresa del remitente. Si Vd. ha recibido este mensaje 
 erroneamente, se ruega lo notifique al remitente y proceda a su borrado. 
Gracias por su colaboracion.

______________________