[mapguide-users] Filter query problem

[Peter Shoemark]

Ok, the solution. (found through Google)

"under some circumstances NOT LIKE and <> simply don't work. As an
alternate try moving the NOT part of the code"

So what worked for me was NOT "NAME" LIKE '%ISLAND'

Perfect. Hope others can get something from this.

Cheers, Peter


On Thu, Feb 7, 2013 at 1:21 PM, Peter Shoemark <shoemark.peter at gmail.com>wrote:

> Guys respectfully I think you are looking too deep.
>
> Yes most certainly NAME   <>   'NEW SOUTH WALES' means I dont want NSW to
> appear from my Australia data feature source and it doesnt.
>
>  Likewise if I add....,"""""" and NAME   <>   'VICTORIA' and NAME   <>
> 'SOUTH AUSTRALIA'"""""", those states also disappear from my outline ,
> exclude the inverted commas.
>
> I suspect in the background of the Layer resource Filter page is a hard
> code that says;
> 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'.
>
> 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.
>
> (NOT LIKE is fine in Oracle SQL and <> is fine in ESRI SQL but NOT LIKE
> doesnt work for me in Maestro).
>
> 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.
>
>
> Cheers, Peter
>
>
> On Thu, Feb 7, 2013 at 12:26 PM, Zac Spitzer <zac.spitzer at gmail.com>wrote:
>
>> I'm not 100% certain, but I think NAME might be a reserved word in some
>> FDO providers?
>>
>>
>> On Thu, Feb 7, 2013 at 10:02 AM, Rémy Gourrat <rgourrat at ag-carto.fr>wrote:
>>
>>> I believe with fdo it's a little different, you must put "no" first
>>>
>>> Not name like '%island'
>>>
>>> If you have an autodesk map you have a good help about.
>>>
>>> Rémy Gourrat
>>> AG-Carto - Bayonne
>>>
>>> ------------------------------
>>> View this message in context: Re: Filter query problem<http://osgeo-org.1560.n6.nabble.com/Filter-query-problem-tp5032605p5032621.html>
>>>
>>> Sent from the MapGuide Users mailing list archive<http://osgeo-org.1560.n6.nabble.com/MapGuide-Users-f4182607.html>at Nabble.com.
>>>
>>> _______________________________________________
>>> mapguide-users mailing list
>>> mapguide-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>
>>>
>>
>>
>> --
>> Zac Spitzer
>> Solution Architect / Director
>> Ennoble Consultancy Australia
>> +61 405 847 168
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20130207/6224a61d/attachment.html>