Hi Jeff,

after experimenting a bit with the queries I ended up using the EXTRACT function and make a filter based on that.
Giving it some second thought, made me realize this is actually much easier:
FILTER ("startdate" <= '2016-01-01' AND "enddate" >= '2016-12-31')

For the time being I think this will work fine until we've added code for the scrolling feature similar to topotijdreis.nl

Met vriendelijke groet,

Daniël Robins
GISArts
www.gisarts.nl
06 13526214

Op 9-8-2016 15:00, Jeff McKenna schreef:
Hi Daniel,

I think for the thousands of readers on this mailing list, you really need to give examples of your psql queries that you are trying (people in these open communities find editing your mistakes much easier than suggesting new solutions). So, dive into the commandline :) Do some tests with the tools I mentioned, then come back here and paste in your query syntax for the mailing list readers, I bet someone will be able to help you then.

-jeff



_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to