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.basq...@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@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
