<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">With Postgres I’d use the DATA statement. I don’t use Oracle so someone else might be in a better position to comment.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Steve.Toutant@inspq.qc.ca [mailto:Steve.Toutant@inspq.qc.ca]
<br>
<b>Sent:</b> Thursday, March 26, 2015 9:27 AM<br>
<b>To:</b> Lime, Steve D (MNIT)<br>
<b>Cc:</b> mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> RE: [mapserver-users] ms7 How to use FILTER<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Thanks Steve, yes it helps!</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">If an SQL query is needed, would you suggest to do it in the DATA statement as a subquery or use</span><span style="font-family:"Arial","sans-serif";color:#004080"> PROCESSING “native_filter=native
SQL string”</span> <o:p></o:p></p>
<p style="margin-bottom:12.0pt"><span style="color:blue">steve</span> <br>
<br>
<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="40%" valign="top" style="width:40.0%;padding:0in 0in 0in 0in;height:6.0pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"Lime, Steve D (MNIT)" <<a href="mailto:Steve.Lime@state.mn.us">Steve.Lime@state.mn.us</a>></span></b><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">
</span><o:p></o:p></p>
<p style="mso-line-height-alt:6.0pt"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">2015-03-26 10:20</span>
<o:p></o:p></p>
</td>
<td width="59%" valign="top" style="width:59.0%;padding:0in 0in 0in 0in;height:6.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">A</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>>, "<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>"
<<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>></span>
<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">cc</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:15.75pt"></td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">Objet</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">RE: [mapserver-users] ms7 How to use FILTER</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="393" style="width:294.75pt;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:6.0pt">
</td>
<td width="336" valign="top" style="width:3.5in;padding:0in 0in 0in 0in;height:6.0pt">
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p><br>
<br>
<br>
<br>
<br>
<span style="font-family:"Arial","sans-serif";color:#004080">MapServer FILTERs are now only written using MapServer expression syntax (e.g. (“[someitem]” != “someval”)). Drivers can support translation capabilities to create native SQL under the hood. This
was done to standardize the syntax across all drivers. Prior to 7.0 the syntax varied by driver. In addition, FILTER values are preserved when used with WFS or native MapServer attribute queries.</span>
<br>
<span style="font-family:"Arial","sans-serif";color:#004080"> </span> <br>
<span style="font-family:"Arial","sans-serif";color:#004080">With database backends there has been little reason to use FILTERs since you could often just extend the DATA statement.
</span><br>
<span style="font-family:"Arial","sans-serif";color:#004080"> </span> <br>
<span style="font-family:"Arial","sans-serif";color:#004080">Note that if need to you can still define a native SQL independently of the DATA statement using the processing tag “native_filter”, for example:</span>
<br>
<span style="font-family:"Arial","sans-serif";color:#004080"> </span> <br>
<span style="font-family:"Arial","sans-serif";color:#004080"> PROCESSING “native_filter=native SQL string”</span>
<br>
<span style="font-family:"Arial","sans-serif";color:#004080"> </span> <br>
<span style="font-family:"Arial","sans-serif";color:#004080">This is also preserved with WFS. Does this help?</span>
<br>
<span style="font-family:"Arial","sans-serif";color:#004080"> </span> <br>
<span style="font-family:"Arial","sans-serif";color:#004080">Steve</span> <br>
<span style="font-family:"Arial","sans-serif";color:#004080"> </span> <br>
<b><span style="font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-family:"Tahoma","sans-serif"">
<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [</span><a href="mailto:mapserver-users-bounces@lists.osgeo.org"><span style="font-family:"Tahoma","sans-serif"">mailto:mapserver-users-bounces@lists.osgeo.org</span></a><span style="font-family:"Tahoma","sans-serif"">]
<b>On Behalf Of </b><a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a><b><br>
Sent:</b> Thursday, March 26, 2015 8:20 AM<b><br>
To:</b> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><b><br>
Subject:</b> [mapserver-users] ms7 How to use FILTER</span> <br>
<br>
<span style="font-family:"Arial","sans-serif"">I'm confused on how to use FILTER when datasource is postgis or Oracle Spatial (Native Connection)</span>
<br>
<span style="font-family:"Arial","sans-serif""><br>
In an old thread, I was told to not use FILTER, but use a WHERE clause in the Data statement.</span>
<span style="font-family:"Arial","sans-serif""><br>
In the ms7 Mapfile-Layer-Data doc, I see for Oracle</span> <span style="font-family:"Arial","sans-serif"">
<br>
"<span style="color:#4F4F4F">Note that there are important performance impacts when using spatial subqueries however. Try using MapServer’s
</span></span><a href="http://mapserver.org/mapfile/layer.html#filter"><span style="font-family:"Arial","sans-serif";color:#1F0062">FILTER</span></a><span style="font-family:"Arial","sans-serif";color:#4F4F4F"> whenever possible instead.</span><span style="font-family:"Arial","sans-serif"">"</span>
<o:p></o:p></p>
<p><span style="font-family:"Arial","sans-serif"">I remember I had a bug with MS6 when using FILTER using WFS. A getfeature on the layer with a spatial or logical filter, the FILTEr in the mapfile was overwritten.</span>
<o:p></o:p></p>
<p><span style="font-family:"Arial","sans-serif"">Please, how should we define/use FILTER int a mapfile with postgis and also oracle (using native connection, not ogr)?</span>
<o:p></o:p></p>
<p style="margin-bottom:12.0pt"><span style="font-family:"Arial","sans-serif"">THANKS!</span>
<br>
<br>
<o:p></o:p></p>
</div>
</body>
</html>