[mapguide-users] Filter query problem

[Peter Shoemark]

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/30f199e8/attachment.html>