Share via

2.2.3.74 CT_Groups

  • Article

Target namespace: http://schemas.microsoft.com/office/accessservices/2010/12/application

Referenced by: CT_Query

Container type for all of the groupings specified in a CT_Query (section 2.2.3.18). MUST contain at least one Group or GroupExpression element. Describes the groups into which records will be placed in the result set. Query results contain one row for each group. If this element is present, then each column that is referenced in a CT_Result (section 2.2.3.8) element MUST be included either in a Group element or in a CT_ExpressionContents (section 2.2.3.45) element that represents an aggregate expression (section 2.1.3.1).

Child Elements:

Group: A CT_Group element that specifies a column from the input sources of a CT_Query (section 2.2.3.18).

GroupExpression: A CT_GroupExpression element that specifies an expression. Query results are grouped based on that expression.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_Groups">
   <xsd:choice maxOccurs="unbounded">
     <xsd:element name="Group" wbld:cname="Group" type="CT_Group"/>
     <xsd:element name="GroupExpression" wbld:cname="GroupExpression" type="CT_GroupExpression"/>
   </xsd:choice>
 </xsd:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).