<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6618.4">
<TITLE>Re: [mapguide-users] Select Distinct QueryOption or Filter?</TITLE>
</HEAD>
<BODY dir=ltr>
<DIV> </DIV>
<DIV>You should use MgFeatureService::SelectAggregates() to do a distinct
select.</DIV>
<DIV>In the FeatureAggregateOptions object that is passed as argument to
that call, make sure you set the distinct flag by calling
MgFeatureAggregateOptions::SelectDistinct(true).</DIV>
<DIV> </DIV>
<DIV>Traian</DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT size=2>-----Original Message----- <BR><B>From:</B> Scott Reisdorf
[mailto:reisdorf1@llnl.gov] <BR><B>Sent:</B> Tue 12/5/2006 7:28 PM
<BR><B>To:</B> users@mapguide.osgeo.org <BR><B>Cc:</B> <BR><B>Subject:</B> Re:
[mapguide-users] Select Distinct QueryOption or Filter?<BR><BR></FONT></DIV>
<P><FONT size=2>Thanks Dave.<BR>I am using SDF3, and from the provider it says
it supports<BR>SelectDistinct
(<SupportsSelectDistinct>true</SupportsSelectDistinct> )<BR>I now
dont know how to set the Flag in the QueryOptions to be
Distinct. <BR>Looking at the API and the code, it does not appear that
the Distinct<BR>option is available on the QueryOptions. Does anyone
know how to select<BR>Distinct Features using the
FeatureService?<BR><BR>Thanks,<BR>-scott<BR><BR>Dave Wilson wrote:<BR>> Not
all providers support distinct.<BR>><BR>> You need to check the
GetCapabilities for each provider via<BR>> <A
href="http://localhost/mapguide/mapagent/index.html">http://localhost/mapguide/mapagent/index.html</A>
under FeatureServices -<BR>> GetProviders will list your providers. Then
using GetCapabilities it<BR>> will indicate if it supports Distinct.
Distinct is a flag in the<BR>> QueryOptions that can be set if I recall
correctly.<BR>><BR>> Dave<BR>><BR>> -----Original
Message-----<BR>> From: Scott Reisdorf [<A
href="mailto:reisdorf1@llnl.gov">mailto:reisdorf1@llnl.gov</A>]<BR>> Sent:
Tuesday, December 05, 2006 2:50 PM<BR>> To:
users@mapguide.osgeo.org<BR>> Subject: [mapguide-users] Select Distinct
QueryOption or Filter?<BR>><BR>> All,<BR>> Is there a way to query
DISTINCT Features when using the<BR>> FeatureService.SelectFeatures() or
SelectAggregrate() with the<BR>> QueryOptions, or possibly is there a
"Distinct" filter option available.<BR>> Any help or code/source
documenting this would be helpful.<BR>><BR>> Thanks,<BR>><BR>>
-scott<BR>><BR>><BR>>
---------------------------------------------------------------------<BR>>
To unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org<BR>> For
additional commands, e-mail:
users-help@mapguide.osgeo.org<BR>><BR>><BR>><BR>>
---------------------------------------------------------------------<BR>>
To unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org<BR>> For
additional commands, e-mail:
users-help@mapguide.osgeo.org<BR>><BR>> <BR><BR>---------------------------------------------------------------------<BR>To
unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org<BR>For additional
commands, e-mail:
users-help@mapguide.osgeo.org<BR><BR></FONT></P></BLOCKQUOTE>
</BODY>
</HTML>