<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.mediumtext
{mso-style-name:medium_text;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.code
{mso-style-name:code;
font-family:"Courier New";
font-weight:normal;
font-style:normal;}
span.charlink
{mso-style-name:char_link;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Times New Roman","serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'>It says “</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Aggregate functions
are not available from a menu”…<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'>The rest means
that the FDO providers themselves are supporting them. The missing piece is the
UI to display the results, which has to be different from the Data Table.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> fdo-users-bounces@lists.osgeo.org
[mailto:fdo-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Martin Morrison<br>
<b>Sent:</b> Tuesday, December 29, 2009 4:50 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> RE: [fdo-users] COUNT, SUM, MAX, MIN...<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>This is taken directly from the AutoCAD MAP help file:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>It clearly states that COUNT, SUM and MAX are supported.
Am I missing something?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>**************************************************************************************************************<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:10.0pt'><a
name=WS1a9193826455f5ff-431507ac11590a0e89b-4></a><span style='font-size:10.0pt;
font-family:"Verdana","sans-serif"'>Aggregate functions are not available from
a menu. They operate on a set of values. These functions are available for
every </span><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:#3366CC'><a href="javascript:hhctrl_d0e5118.Click()"><span
style='color:green;font-weight:normal;text-decoration:none'>data provider</span></a></span></b><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'> except for raster,
WFS, and WMS providers (which can use only the SpatialExtent function.<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 width="100%"
style='width:100.0%;background:#F2F2F2;border-top:solid #3D3D3D 3.0pt;
border-left:none;border-bottom:solid #3D3D3D 2.25pt;border-right:none'>
<tr>
<td style='border:none;background:#3D3D3D;padding:2.25pt 10.0pt 6.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:16.8pt;margin-right:0in;
margin-bottom:16.8pt;margin-left:0in;line-height:15.6pt'><a
name=WS73099cc142f48755-e1f2279115824679ea-75></a><b><span style='font-size:
10.0pt;font-family:"Verdana","sans-serif";color:white'>Option<o:p></o:p></span></b></p>
</td>
<td style='border:none;background:#3D3D3D;padding:2.25pt 10.0pt 6.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:16.8pt;margin-right:0in;
margin-bottom:16.8pt;margin-left:0in;line-height:15.6pt'><b><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:white'>Definition<o:p></o:p></span></b></p>
</td>
<td style='border:none;background:#3D3D3D;padding:2.25pt 10.0pt 6.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:16.8pt;margin-right:0in;
margin-bottom:16.8pt;margin-left:0in;line-height:15.6pt'><b><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:white'>Syntax<o:p></o:p></span></b></p>
</td>
<td style='border:none;background:#3D3D3D;padding:2.25pt 10.0pt 6.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:16.8pt;margin-right:0in;
margin-bottom:16.8pt;margin-left:0in;line-height:15.6pt'><b><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:white'>Example<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><a
name=WS73099cc142f48755-6ab6cd0115aeafde51-7b><span style='font-size:10.0pt;
font-family:"Verdana","sans-serif"'>AVG</span></a><span style='font-size:
10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><a
name=WS1a9193826455f5ff1dbc298511635bea87551e><span style='font-size:10.0pt;
font-family:"Verdana","sans-serif"'>Returns the average of the values as a
Double data type.</span></a><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>You can specify an
optional argument: ALL or DISTINCT. <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>For example: </span><span
style='font-size:10.0pt;font-family:"Courier New"'>AVG(Id), AVG('all', Id),
AVG('distinct', Id)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>AVG('all',
Numeric_property)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><a
name=WS1a9193826455f5ff-523e3b0b115ce278e625b><span style='font-size:10.0pt;
font-family:"Courier New"'>AVG('all', Parcel_Value)</span></a><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>This example
finds the average of all parcels that have a Parcel_Value property, including
the ones that are null or empty.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>COUNT<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Returns the
number of rows as an Int64 data type.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>You can specify
an optional argument: ALL or DISTINCT. <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>For example: </span><span
style='font-size:10.0pt;font-family:"Courier New"'>COUNT(Id), COUNT('all',
Id), COUNT('distinct', Id)</span><span style='font-size:10.0pt;font-family:
"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>COUNT('optional_argument',
Numeric_property)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>COUNT('all', Parcel_ID)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>This example
counts all the rows containing a Parcel_ID property, including the ones that
are null or empty.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>MAX<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Returns the
maximum value with the same data type as the input parameter.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>You can specify
an optional argument: ALL or DISTINCT. <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>For example: </span><span
style='font-size:10.0pt;font-family:"Courier New"'>MAX(Id), MAX('all', Id),
MAX('distinct', Id)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>MAX('optional_argument',
Numeric_property)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>MAX('all', Parcel_Area)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>This example
finds the largest parcel area value for all parcels containing a Parcel_Area
property, including the ones that are null or empty.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>MEDIAN<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Takes a numeric
value and returns the middle value or an interpolated value that would be the
middle value once the values are sorted. The returned value has the same data
type as the input parameter.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><a
name=WS1a9193826455f5ff32cd3be2115aeb01b9d-7b></a><span style='font-size:
10.0pt;font-family:"Verdana","sans-serif"'>Represents an inverse distribution
function that assumes a continuous distribution model.<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>MEDIAN(Numeric_ property)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>MEDIAN(Parcel_Value)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>This example
finds the median value for all parcels that have a Parcel_Value property. It
includes parcels with null or empty values for Parcel_Value if it is a
numeric property.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>MIN<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><a
name=WS1a9193826455f5ff1dbc298511635bea87551f><span style='font-size:10.0pt;
font-family:"Verdana","sans-serif"'>Returns the minimum value with the same
data type as the input parameter. The returned value has the same data type
as the input parameter.</span></a><span style='font-size:10.0pt;font-family:
"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>You can specify
an optional argument: ALL or DISTINCT. <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>For example: </span><span
style='font-size:10.0pt;font-family:"Courier New"'>Min(Id), Min('all', Id),
Min('distinct', Id)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>MIN('optional_argument',
Numeric_property)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>MIN('all', Parcel_Area)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>This example
finds the area of the smallest parcel that has a Parcel_Area property, including
the ones that are null or empty.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><a
name=WS1a9193826455f5ff-21cb8bba116ed45764c-7></a><span style='font-size:
10.0pt;font-family:"Verdana","sans-serif"'>SPATIALEXTENT<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Returns the
smallest possible bounding rectangle of all geometries in a layer.<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>SPATIALEXTENT(geometry)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>SPATIALEXTENT(geometry)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>STDDEV<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Returns the
sample standard deviation as a Double data type.<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>STDDEV(Numeric_property)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>STDDEV(Parcel_Value)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>This example
finds the standard deviation among parcel values for all parcels with a
Parcel_Value property, including the ones that are null or empty.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>SUM<o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Returns the sum of
the values as a Double data type.<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>You can specify
an optional argument: ALL or DISTINCT. <o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>For example: </span><span
style='font-size:10.0pt;font-family:"Courier New"'>Sum(Id), Sum('all', Id),
Sum('distinct', Id)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>SUM('all',
Numeric_property)</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
</td>
<td valign=bottom style='border:none;border-bottom:solid #3D3D3D 1.0pt;
background:transparent;padding:4.0pt 10.0pt 5.0pt 10.0pt'>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Courier New"'>SUM('all', Parcel_Value)</span><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:2.0pt;margin-right:0in;
margin-bottom:2.0pt;margin-left:0in;line-height:15.6pt'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>This example
finds the total of parcel values for all parcels with a Parcel_Value
property, including the ones that are null or empty.<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>**************************************************************************************************************<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Dan Stoica<br>
<b>Sent:</b> Tuesday, December 29, 2009 3:42 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> RE: [fdo-users] COUNT, SUM, MAX, MIN...<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'>Indeed, MAP doesn’t
have such functionality. Instead some partners developed the appropriate
UI. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'>I’ll send
Jose the contact info.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'>Dan.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> fdo-users-bounces@lists.osgeo.org
[mailto:fdo-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Jose Antonio
Moran<br>
<b>Sent:</b> Tuesday, December 29, 2009 10:16 AM<br>
<b>To:</b> fdo-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [fdo-users] COUNT, SUM, MAX, MIN...<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Good afternoon,<br>
when i employ in the Expression Builder MAX, for example, I obtain the next
message:<br>
<br>
<span class=mediumtext><i><span style='background:white'>The expression is
invalid </span></i></span><i><span style='background:white'><br>
<span class=mediumtext>Error: The expression contains undefined function 'MAX'.
Click here to move the cursor to the error (1) # 1</span></span></i><br>
<br>
I am using Autocad Map 2010 and a SDF file.<br>
<br>
Greatings.<br>
<br>
El 29/12/2009 14:33, Martin Morrison escribió: <o:p></o:p></p>
<pre>You don't need to add it, it is already there. Use the Expression Builder. Search help for "aggregate options".<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Martin<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>-----Original Message-----<o:p></o:p></pre><pre>From: <a
href="mailto:fdo-users-bounces@lists.osgeo.org">fdo-users-bounces@lists.osgeo.org</a> [<a
href="mailto:fdo-users-bounces@lists.osgeo.org">mailto:fdo-users-bounces@lists.osgeo.org</a>] On Behalf Of brujulas<o:p></o:p></pre><pre>Sent: Tuesday, December 29, 2009 6:50 AM<o:p></o:p></pre><pre>To: <a
href="mailto:fdo-users@lists.osgeo.org">fdo-users@lists.osgeo.org</a><o:p></o:p></pre><pre>Subject: [fdo-users] COUNT, SUM, MAX, MIN...<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>Hi, <o:p></o:p></pre><pre>I work with Autocad Map and for a new project I need to make COUNT and SUM<o:p></o:p></pre><pre>of several registers in Oracle (like in Arcgis is possible)<o:p></o:p></pre><pre>I have no idea how to add this funcionallity to my Autocad Map, anybody can<o:p></o:p></pre><pre>help me??<o:p></o:p></pre><pre>Regards<o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p>
<div>
<p class=MsoNormal>-- <br>
<img border=0 width=834 height=268 id="_x0000_i1025"
src="cid:image001.jpg@01CA88CB.1A4E05E0"><o:p></o:p></p>
</div>
</div>
</body>
</html>