2.2.3.72 CT_Group

  • Article

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

Referenced by: CT_Groups

Specifies a single column from the input sources on which to group the CT_Results (section 2.2.3.9). The query results will have one group for each unique value in the data of that column.

Attributes:

Name: An ST_LongString (section 2.2.4.4) attribute that specifies the name of one column from the input source specified by the Source attribute.

Source: An ST_ObjectName (section 2.2.4.1) attribute that specifies the name or alias of one of the input sources to the query. The input source MUST be listed in the CT_References (section 2.2.3.7) collection of the query. If the CT_Reference (section 2.2.3.6) element specifying the input source contains an Alias value, then this attribute MUST be that value.

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

 <xsd:complexType name="CT_Group">
   <xsd:attribute name="Source" type="ST_ObjectName" wbld:cname="Source" use="required"/>
   <xsd:attribute name="Name" type="ST_LongString" wbld:cname="Name" use="required"/>
 </xsd:complexType>

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