<div dir="ltr">Ok, the solution. (found through Google)<div><br></div><div style>"under some circumstances NOT LIKE and <> simply don't work. As an alternate try moving the NOT part of the code"</div><div style>
<br></div><div style>So what worked for me was NOT "NAME" LIKE '%ISLAND'</div><div style><br></div><div style>Perfect. Hope others can get something from this.</div><div style><br></div><div style>Cheers, Peter</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Feb 7, 2013 at 1:21 PM, Peter Shoemark <span dir="ltr"><<a href="mailto:shoemark.peter@gmail.com" target="_blank">shoemark.peter@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">Guys respectfully I think you are looking too deep.<div><br></div><div>Yes most certainly NAME <> 'NEW SOUTH WALES' means I dont want NSW to appear from my Australia data feature source and it doesnt.</div>
<div><br></div><div> Likewise if I add....,"""""" and NAME <> 'VICTORIA' and NAME <> 'SOUTH AUSTRALIA'"""""", those states also disappear from my outline , exclude the inverted commas.</div>
<div><br></div><div>I suspect in the background of the Layer resource Filter page is a hard code that says;</div><div>Select * from your.featuresource where........... then you add your code here at the Layers->Filter line, which in my case is NAME <> 'NEW SOUTH WALES'.</div>
<div><br></div><div>What I also want it to do is say code that equals.....NAME <> 'wildcard ISLAND' so that I dont get the NME NEW SOUTH WALES or any of the *ISLAND names.</div><div><br></div>
<div>(NOT LIKE is fine in Oracle SQL and <> is fine in ESRI SQL but NOT LIKE doesnt work for me in Maestro).</div><div><br></div><div>Hope that explains my predicament a bit better. Yes of course I could make a separate layer in MAP or ARC to separate the *ISLAND bit but I am sure that wont be necessary with help from this group.</div>
<div><br></div><div><br></div><div>Cheers, Peter</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Feb 7, 2013 at 12:26 PM, Zac Spitzer <span dir="ltr"><<a href="mailto:zac.spitzer@gmail.com" target="_blank">zac.spitzer@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">I'm not 100% certain, but I think NAME might be a reserved word in some FDO providers?<br></div><div class="gmail_extra">
<br><br><div class="gmail_quote"><div><div>On Thu, Feb 7, 2013 at 10:02 AM, Rémy Gourrat <span dir="ltr"><<a href="mailto:rgourrat@ag-carto.fr" target="_blank">rgourrat@ag-carto.fr</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>I believe with fdo it's a little different, you must put "no" first
<br><br>Not name like '%island'
<br><br>If you have an autodesk map you have a good help about.
<br><br>Rémy Gourrat
<div style="margin-top:1em;color:#666666;font-size:11px">
AG-Carto - Bayonne
</div>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.n6.nabble.com/Filter-query-problem-tp5032605p5032621.html" target="_blank">Re: Filter query problem</a><div><div><br>
Sent from the <a href="http://osgeo-org.1560.n6.nabble.com/MapGuide-Users-f4182607.html" target="_blank">MapGuide Users mailing list archive</a> at Nabble.com.<br></div></div><br></div></div><div>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></div></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br>Zac Spitzer<br>Solution Architect / Director<br>Ennoble Consultancy Australia<br><a href="tel:%2B61%20405%20847%20168" value="+61405847168" target="_blank">+61 405 847 168</a><br>
<br>
</font></span></div>
<br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>