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 <[email protected]>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 <[email protected]>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 <[email protected]>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 >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >>> >> >> >> -- >> Zac Spitzer >> Solution Architect / Director >> Ennoble Consultancy Australia >> +61 405 847 168 >> >> >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> >
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
