<div dir="ltr">If you're using mapserver, your syntax and the docs probably need to be updated. Try:<div><br></div><div><span style="color:rgb(33,33,33)">FILTER ( "[gid]" = "[%adrkey%]" )</span><br class="gmail_msg" style="color:rgb(33,33,33)"></div><div><span style="color:rgb(33,33,33)"><br></span></div><div><span style="color:rgb(33,33,33)">please submit a PR to the docs if that solved the issue.</span></div><div><span style="color:rgb(33,33,33)">--</span></div><div><span style="color:rgb(33,33,33)">thomas</span></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Jan 4, 2017 at 12:27 PM Jörg Thomsen (WhereGroup) <<a href="mailto:joerg.thomsen@wheregroup.com">joerg.thomsen@wheregroup.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello and a happy new year!<br class="gmail_msg">
<br class="gmail_msg">
I have had some problems with variable subst. and the FILTER keyword,<br class="gmail_msg">
following the example from <a href="http://mapserver.org/cgi/runsub.html#filters" rel="noreferrer" class="gmail_msg" target="_blank">http://mapserver.org/cgi/runsub.html#filters</a><br class="gmail_msg">
I first tried<br class="gmail_msg">
<br class="gmail_msg">
> VALIDATION<br class="gmail_msg">
> 'adrkey' '[0-9]'<br class="gmail_msg">
> END<br class="gmail_msg">
><br class="gmail_msg">
> FILTER ('gid=%adrkey%')<br class="gmail_msg">
<br class="gmail_msg">
but this doesn't work, mapserver seems not to put the filteritem into<br class="gmail_msg">
the sql-request:<br class="gmail_msg">
> [Wed Jan 4 11:36:24 2017].762361 msPostGISLayerWhichShapes(): Error (ERROR: syntax error at or near "="<br class="gmail_msg">
> LINE 1: ...019,333328.511788558 5808847.26502019))',25833) and ( = '1')<br class="gmail_msg">
<br class="gmail_msg">
then I had a look at expression-page<br class="gmail_msg">
(<a href="http://mapserver.org/mapfile/expressions.html" rel="noreferrer" class="gmail_msg" target="_blank">http://mapserver.org/mapfile/expressions.html</a>) and tried<br class="gmail_msg">
<br class="gmail_msg">
> FILTERITEM 'gid'<br class="gmail_msg">
> FILTER '%adrkey%'<br class="gmail_msg">
which works.<br class="gmail_msg">
<br class="gmail_msg">
is there any mistake in my first try or doesn't this work anymore an the<br class="gmail_msg">
doc on <a href="http://mapserver.org/cgi/runsub.html#filters" rel="noreferrer" class="gmail_msg" target="_blank">http://mapserver.org/cgi/runsub.html#filters</a> should be updated?<br class="gmail_msg">
<br class="gmail_msg">
Regards, Jörg<br class="gmail_msg">
<br class="gmail_msg">
--<br class="gmail_msg">
<br class="gmail_msg">
*********************************************************<br class="gmail_msg">
FOSS Academy Winterschule 2017<br class="gmail_msg">
20.-24.03.2017 in Bonn<br class="gmail_msg">
Alles Wichtige zur Erstellung einer GDI in nur 5 Tagen!<br class="gmail_msg">
<a href="https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule" rel="noreferrer" class="gmail_msg" target="_blank">https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule</a><br class="gmail_msg">
*********************************************************<br class="gmail_msg">
<br class="gmail_msg">
-------------------------------<br class="gmail_msg">
Jörg Thomsen<br class="gmail_msg">
WhereGroup GmbH & Co. KG<br class="gmail_msg">
Gillweg 3<br class="gmail_msg">
14193 Berlin<br class="gmail_msg">
Germany<br class="gmail_msg">
<br class="gmail_msg">
Fon: <a href="tel:+49%2030%20513027874" value="+4930513027874" class="gmail_msg" target="_blank">+49 (0)30 / 5130 278 74</a><br class="gmail_msg">
Fax: <a href="tel:+49%2030%2089095321" value="+493089095321" class="gmail_msg" target="_blank">+49 (0)30 / 89 09 53 21</a><br class="gmail_msg">
<br class="gmail_msg">
<a href="mailto:joerg.thomsen@wheregroup.com" class="gmail_msg" target="_blank">joerg.thomsen@wheregroup.com</a><br class="gmail_msg">
<a href="http://www.wheregroup.com" rel="noreferrer" class="gmail_msg" target="_blank">www.wheregroup.com</a><br class="gmail_msg">
Amtsgericht Bonn, HRA 6788<br class="gmail_msg">
-------------------------------<br class="gmail_msg">
Komplementärin:<br class="gmail_msg">
WhereGroup Verwaltungs GmbH<br class="gmail_msg">
vertreten durch:<br class="gmail_msg">
Olaf Knopp, Peter Stamm<br class="gmail_msg">
-------------------------------<br class="gmail_msg">
Folgen Sie der WhereGroup auf twitter: <a href="http://twitter.com/WhereGroup_com" rel="noreferrer" class="gmail_msg" target="_blank">http://twitter.com/WhereGroup_com</a><br class="gmail_msg">
_______________________________________________<br class="gmail_msg">
mapserver-users mailing list<br class="gmail_msg">
<a href="mailto:mapserver-users@lists.osgeo.org" class="gmail_msg" target="_blank">mapserver-users@lists.osgeo.org</a><br class="gmail_msg">
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></blockquote></div>