[mapserver-users] Oracle SYSDATE in EXPRESSION

[Dan Little]

You're probably better off with a view or querying against a stored
procedure. There are a few advantages:
1. With a view you can create multiple arbitrary views.
2. It keeps the syntax of the mapfile cleaner.
3. A view is easy to change to a materialized view in Oracle.  That has a
pile of performance benefits.
4. A stored procedure can be used to normalize the data better between
Oracle and mapserver.


On Tue, Mar 29, 2016 at 10:53 AM, Basques, Bob (CI-StPaul) <
bob.basques at ci.stpaul.mn.us> wrote:

> All Oracle Guru’s,
>
> How do I handle an expression for doing a timed query in Oracle:
>
> CLASS
> *EXPRESSION ('[indate] > SYSDATE - 1825')*
> COLOR 255 255 254
> OUTLINECOLOR 0 0 0
>       SIZE 10
>       SYMBOL 'circle'
> NAME "PW Sidewalk Permits"
>     END
>
> I want to get all the Permits up to 5 years old to plot.  What should the
> EXPRESSION line look like above.  I’ve tried all sort of different
> combinations of quoting, etc.  I either get everything, or nothing.
>
> Thanks
>
> bobb
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160329/d37c40d7/attachment.htm>