[mapguide-users] MgOrderingOption?

[Chris Gountanis]

On a "Developer" side note it would be really nice if the queryOptions
.SetFilter allowed you to run true SQL like ORDER BY on all connections.


String filter = "OWNER LIKE '" + searchstring + "% ORDER BY OWNER'";   
MgFeatureQueryOptions queryOptions = new MgFeatureQueryOptions();
queryOptions.SetFilter(filter);
 
Chris



-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Chris Gountanis
Sent: Thursday, February 08, 2007 9:20 AM
To: 'MapGuide Users Mail List'
Subject: RE: [mapguide-users] MgOrderingOption?

Thanks Warren,

Well the fact that you can't order data coming directly out of an SDF or SHP
really hurts. I don't mind taking a single link and going external for data
but... that really hurts.


Chris
 
 
 
-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Warren
Medernach
Sent: Thursday, February 08, 2007 9:09 AM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] MgOrderingOption?

Hey Chris,

I believe this is controlled differently by each type of feature source,
and you can see the options by using the GetCapabilities under the
MapAgent index.  Look for the SupportsSelectOrdering

Some features support ordering (Oracle, SQL Server)... 
Others do not (SHP, SDF)...

Hope this helps

   Warren Medernach
   IMAGINiT Professional Services

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Chris
Gountanis
Sent: Thursday, February 08, 2007 8:54 AM
To: 'MapGuide Users Mail List'
Subject: [mapguide-users] MgOrderingOption?

How do you use MgOrderingOption to sort a featureset?


queryOptions.SetFilter(filter);

MgOrderingOption orderingOption = new MgOrderingOption();
orderingOption.Equals = "OWNERNAME"; ???


queryOptions.SetOrderingFilter(orderingOption,1);


Chris


_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users