<p dir="ltr">You could use a regex in your database query. With '^%nom%$' in your expression, and .* as your default_nom</p>
<div class="gmail_quote">On Mar 11, 2016 4:00 PM, "milad nidal" <<a href="mailto:miladnidal2604@gmail.com">miladnidal2604@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><p class="MsoNormal"><br></p><p class="MsoNormal"><span lang="EN-CA">But this
example is using the same layer twice which I do not want.. Even in this example if we do not
use value we get nothing and only one layer will be visualised.. </span></p>
<p class="MsoNormal"><span lang="EN-CA">Maybe I was
not clear enough in my question.. I want to visualise all the municipalities
then I want to apply the filter to visualize only one. I thought maybe there is
something like ‘default_value’ ‘all’ </span><span lang="EN-CA" style="font-family:Wingdings">J</span><span lang="EN-CA">.</span></p>
<p class="MsoNormal"><span lang="EN-CA"> </span></p>
<p class="MsoNormal"><span lang="EN-CA">thanks</span></p></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Mar 11, 2016 at 9:38 AM, <span dir="ltr"><<a href="mailto:lars.schylberg@blixtmail.se" target="_blank">lars.schylberg@blixtmail.se</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div dir="ltr">Here is a full example with a default value also:
<br>
<br><a href="http://linfiniti.com/2011/09/making-the-most-of-umn-mapserver-runtime-variable-substitution/" target="_blank">http://linfiniti.com/2011/09/making-the-most-of-umn-mapserver-runtime-variable-substitution/</a>
<br>
<br>/Lars S.
<br>
<br>
<blockquote dir="ltr" style="border-left:2px solid blue;margin:5pt 0 5pt 10pt;padding:0 0 0 5pt;font-size:13px;font-family:tahoma,helvetica,sans-serif">
<hr size="1">-----Originalmeddelande-----
<br>Från: "milad nidal" <<a href="mailto:miladnidal2604@gmail.com" target="_blank">miladnidal2604@gmail.com</a>>
<br>Till: "Richard Greenwood" <<a href="mailto:richard.greenwood@gmail.com" target="_blank">richard.greenwood@gmail.com</a>>, "MapserverList OSGEO" <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>>
<br>Datum: 2016-03-11 14:31
<br>Ämne: Re: [mapserver-users] Runtime variable Substitution Filter
<br><div><div>
<br>
<div dir="ltr">
<div>
<p class="MsoNormal">
<span style="background-image:initial;background-repeat:initial" lang="EN-CA">Could you please explain more about how to do it (the first time which I'm using this variable)..</span>
</p>
<p class="MsoNormal">
<span style="background-image:initial;background-repeat:initial" lang="EN-CA">Do you mean that I use 'default_nom' ' aaa' in the layer metadata (it does not work).. where I should put the default value?</span>
</p>
<p class="MsoNormal"></p>
<p class="MsoNormal">
<span style="background-image:initial;background-repeat:initial" lang="EN-CA">Thanks</span>
</p>
</div>
</div>
<div class="gmail_extra">
<br>
<div class="gmail_quote">On Thu, Mar 10, 2016 at 11:06 PM, Richard Greenwood
<span dir="ltr"><
<a href="mailto:richard.greenwood@gmail.com" target="_blank">richard.greenwood@gmail.com</a>></span> wrote:
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<span style="font-size:12.8px">Michael's suggestion is very good. Another method would be to define the later twice with two different names and no filter in one of the definitions. That would also allow you to style the layer differently which might be desirable.</span>
<br>
<div>
<span style="font-size:12.8px">
<br>
</span>
</div>
<div>
<span style="font-size:12.8px">Rich</span>
</div>
</div>
<div class="gmail_extra">
<div>
<div>
<br>
<div class="gmail_quote">On Thu, Mar 10, 2016 at 6:44 PM, Michael Smith
<span dir="ltr"><
<a href="mailto:michael.smith.erdc@gmail.com" target="_blank">michael.smith.erdc@gmail.com</a>></span> wrote:
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="auto">
<div>You can set a default value for your layer when no value is set. What I do is set it to something like 1=1 and then all values will display.
<a href="http://mapserver.org/cgi/runsub.html#default-values-if-not-provided-in-the-url" target="_blank">http://mapserver.org/cgi/runsub.html#default-values-if-not-provided-in-the-url</a>
</div>
<div>
<br>
</div>
<div>
<br>
<br>Michael Smith
<div>Remote Sensing/GIS Center</div>
<div>US Army Corps of Engineers</div>
</div>
<div>
<div>
<div>
<br>On Mar 10, 2016, at 8:36 PM, milad nidal <
<a href="mailto:miladnidal2604@gmail.com" target="_blank">miladnidal2604@gmail.com</a>> wrote:
<br>
<br>
</div>
<blockquote type="cite">
<div>
<div dir="ltr">
<p style="margin-bottom:0cm" lang="en-CA">Hi,</p>
<p style="margin-bottom:0cm" lang="en-CA">I'm using Runtime variable Substitution (FILTER "nom in ( %municipalitylist% )") to chose one municipality from a list and it is going good. But how I can visualize all the municipalities in the layer? Is-it possible to ignore the filter?</p>
<p style="margin-bottom:0cm" lang="en-CA">
<br>
</p>
<p style="margin-bottom:0cm" lang="en-CA">
<br>
</p>
<p style="margin-bottom:0cm" lang="en-CA">Thanks</p>
</div>
</div>
</blockquote>
</div>
</div>
<blockquote type="cite">
<div>
<span>_______________________________________________</span>
<br>
<span>mapserver-users mailing list</span>
<br>
<span>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>
</span>
<br>
<span>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</span>
</div>
</blockquote>
</div>
<br>_______________________________________________
<br>mapserver-users mailing list
<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>
<br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div>
<br>
</div>
</div>
</div>
<span>
<font color="#888888">--
<br></font>
</span>
<div>
<div dir="ltr">
<span>
<font color="#888888">Richard W. Greenwood, PLS
<br>
<a href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a></font>
</span>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div></div><hr><span>_______________________________________________
<br>mapserver-users mailing list
<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>
<br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</span></blockquote>
<br>
<br>
<div>
<div>--</div>
</div>
</div>
</div>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></blockquote></div>