<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>Hi Scott,</DIV>
<DIV> </DIV>
<DIV>The 'distinct' option is available with the SelectAggregates command
(FdoISelectAggregates). When you use distinct, you're selecting distinct values
of properties and not actual features at that point.</DIV>
<DIV> </DIV>
<DIV>Orest.</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.</FONT> <BR><FONT size=2>I am using SDF3, and from
the provider it says it supports </FONT><BR><FONT size=2>SelectDistinct
(<SupportsSelectDistinct>true</SupportsSelectDistinct> )</FONT>
<BR><FONT size=2>I now dont know how to set the Flag in the QueryOptions to be
Distinct. </FONT><BR><FONT size=2>Looking at the API and the code, it
does not appear that the Distinct </FONT><BR><FONT size=2>option is available
on the QueryOptions. Does anyone know how to select </FONT><BR><FONT
size=2>Distinct Features using the FeatureService?</FONT> </P>
<P><FONT size=2>Thanks,</FONT> <BR><FONT size=2>-scott</FONT> </P>
<P><FONT size=2>Dave Wilson wrote:</FONT> <BR><FONT size=2>> Not all
providers support distinct.</FONT> <BR><FONT size=2>></FONT> <BR><FONT
size=2>> You need to check the GetCapabilities for each provider via</FONT>
<BR><FONT size=2>> <A
href="http://localhost/mapguide/mapagent/index.html">http://localhost/mapguide/mapagent/index.html</A>
under FeatureServices -</FONT> <BR><FONT size=2>> GetProviders will list
your providers. Then using GetCapabilities it</FONT> <BR><FONT size=2>>
will indicate if it supports Distinct. Distinct is a flag in the</FONT>
<BR><FONT size=2>> QueryOptions that can be set if I recall
correctly.</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>
Dave</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>> -----Original
Message-----</FONT> <BR><FONT size=2>> From: Scott Reisdorf [<A
href="mailto:reisdorf1@llnl.gov">mailto:reisdorf1@llnl.gov</A>]
</FONT><BR><FONT size=2>> Sent: Tuesday, December 05, 2006 2:50 PM</FONT>
<BR><FONT size=2>> To: users@mapguide.osgeo.org</FONT> <BR><FONT
size=2>> Subject: [mapguide-users] Select Distinct QueryOption or
Filter?</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>> All,</FONT>
<BR><FONT size=2>> Is there a way to query DISTINCT Features when using
the</FONT> <BR><FONT size=2>> FeatureService.SelectFeatures() or
SelectAggregrate() with the</FONT> <BR><FONT size=2>> QueryOptions, or
possibly is there a "Distinct" filter option available.</FONT> <BR><FONT
size=2>> Any help or code/source documenting this would be helpful.</FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>> Thanks,</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>> -scott</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>
---------------------------------------------------------------------</FONT>
<BR><FONT size=2>> To unsubscribe, e-mail:
users-unsubscribe@mapguide.osgeo.org</FONT> <BR><FONT size=2>> For
additional commands, e-mail: users-help@mapguide.osgeo.org</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>></FONT>
<BR><FONT size=2>>
---------------------------------------------------------------------</FONT>
<BR><FONT size=2>> To unsubscribe, e-mail:
users-unsubscribe@mapguide.osgeo.org</FONT> <BR><FONT size=2>> For
additional commands, e-mail: users-help@mapguide.osgeo.org</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>> </FONT></P>
<P><FONT
size=2>---------------------------------------------------------------------</FONT>
<BR><FONT size=2>To unsubscribe, e-mail:
users-unsubscribe@mapguide.osgeo.org</FONT> <BR><FONT size=2>For additional
commands, e-mail: users-help@mapguide.osgeo.org</FONT>
</P></BLOCKQUOTE>
</BODY>
</HTML>