Re: [mapserver-users] Mapserver filter/expression by DATE

[Daniël Robins]

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

Re: [mapserver-users] Mapserver filter/expression by DATE

[Yves Jacolin]

Hello,

I just sent a PR to remove uk flag and translation.

As Jeff said in the ticket, there is no translated string for Ukraine.

Thanks Jeff and Ian.

Y.
On Tuesday, August 09, 2016 13:48:08 Jeff McKenna wrote:
> Good catch Ian, I can see inside the docs source paths of
> "translated/uk", so it is on our side.  I've created a ticket for this,
> and I will now attempt to change that to the proper "ua" country code.
> https://github.com/mapserver/docs/issues/150
> 
> -jeff
> 
> On 2016-08-09 11:04 AM, Ian Turton wrote:
> > I have http://mapserver.org/uk/ogc/wms_dimension.html as my dimension,
> > which seems wrong as ususally I would be GB or en_gb  in this context.
> > 
> > However I believe that the 2 letter Ukrainian code is 'UA' not UK for
> > exactly this reason (see https://en.wikipedia.org/wiki/ISO_3166-2:UA) -
> > I think neither of us is supposed to use UK so as to avoid confusing
> > other people.
> > 
> > Ian

-- 
Responsable Formation et Support
Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex
Tel (France) : +33 4 58 48 20 43 (new !)
Tel (Suisse) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
Fax : 04 79 70 15 81
Mail : yves.jaco...@camptocamp.com
http://www.camptocamp.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users