<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
I went the view route for the time being, to get one of the class types (layer) up and running. I was basing my questions on the fact that I’ve successfully passed in all sorts of SQL into the Postgres connector with MapServer, but the Oracle connector seems
to be some limited in what it can send in successfully, or there are some escaping sequences I don’t know about.
<div class=""><br class="">
</div>
<div class="">I tried a few things for making it work the fly, but nothing was working.</div>
<div class=""><br class="">
</div>
<div class="">I ended up creating a view as Dan Little suggested. I could probably get by with doing the FOLDERTYPE filtering (Last line below) in the MapFile as a quick way of making all the Permit class types work.</div>
<div class=""><br class="">
</div>
<div class="">
<div class=""><font face="Courier New" class="">create view </font></div>
<div class=""><font face="Courier New" class=""> PW_SK_Permits </font></div>
<div class=""><font face="Courier New" class="">as</font></div>
<div class=""><font face="Courier New" class="">select</font></div>
<div class=""><font face="Courier New" class=""> P.DEPARTMENT,</font></div>
<div class=""><font face="Courier New" class=""> P.INDATE,</font></div>
<div class=""><font face="Courier New" class=""> CASE WHEN</font></div>
<div class=""><font face="Courier New" class=""> P.INDATE < SYSDATE - 365 * 5</font></div>
<div class=""><font face="Courier New" class=""> THEN</font></div>
<div class=""><font face="Courier New" class=""> 'older'</font></div>
<div class=""><font face="Courier New" class=""> ELSE</font></div>
<div class=""><font face="Courier New" class=""> 'newer'</font></div>
<div class=""><font face="Courier New" class=""> END as age,</font></div>
<div class=""><font face="Courier New" class=""> P.FOLDERTYPE, </font></div>
<div class=""><font face="Courier New" class=""> P.FOLDERDESC,</font></div>
<div class=""><font face="Courier New" class=""> P.FOLDERRSN,</font></div>
<div class=""><font face="Courier New" class=""> P.FOLDERID,</font></div>
<div class=""><font face="Courier New" class=""> A.PIN,</font></div>
<div class=""><font face="Courier New" class=""> A.GEOMETRY,</font></div>
<div class=""><font face="Courier New" class=""> A.OGR_FID</font></div>
<div class=""><font face="Courier New" class="">from </font></div>
<div class=""><font face="Courier New" class=""> STAMP.PW_Permits P, ADDRESS_ACTIVE_OGR_VIEW A</font></div>
<div class=""><font face="Courier New" class="">where </font></div>
<div class=""><font face="Courier New" class=""> P.PIN is not NULL</font></div>
<div class=""><font face="Courier New" class="">and</font></div>
<div class=""><font face="Courier New" class=""> P.PIN = A.PIN</font></div>
<div class=""><font face="Courier New" class="">and</font></div>
<div class=""><font face="Courier New" class=""> P.FOLDERTYPE IN ('SK') -- PW Sidewalks</font></div>
<div class=""><br class="">
</div>
<div class="">I needed to get this SideWalk Permit layer up and running either way. Something similar to the inner select above works just fine via MapServer/Postgres though.</div>
<div class=""><br class="">
</div>
<div class="">Now how to figure things out for the other 119 permit types. :c)</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">
<div>
<blockquote type="cite" class="">
<div class="">On Apr 4, 2016, at 5:28 AM, Martin Icking <<a href="mailto:martin.icking@bentley.com" class="">martin.icking@bentley.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div class="">Or you could create a calculated column in the data statement, call it e.g.<br class="">
"AGE" being the result of the difference of your original date column and<br class="">
the oracle sysdate.<br class="">
Then you can easily use that "AGE" column to do your styling.<br class="">
<br class="">
HTH<br class="">
Martin<br class="">
<br class="">
<br class="">
<br class="">
--<br class="">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Oracle-SYSDATE-in-EXPRESSION-tp5258709p5259480.html" class="">
http://osgeo-org.1560.x6.nabble.com/Oracle-SYSDATE-in-EXPRESSION-tp5258709p5259480.html</a><br class="">
Sent from the Mapserver - User mailing list archive at <a href="http://nabble.com" class="">
Nabble.com</a>.<br class="">
_______________________________________________<br class="">
mapserver-users mailing list<br class="">
<a href="mailto:mapserver-users@lists.osgeo.org" class="">mapserver-users@lists.osgeo.org</a><br class="">
http://lists.osgeo.org/mailman/listinfo/mapserver-users</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</body>
</html>