2.2.3.4 CT_Order

  • Article

Target namespace: http://schemas.microsoft.com/office/accessservices/2009/11/application

Referenced by: CT_Ordering

Specifies a single order to apply to a Query.

Attributes:

Direction : An ST_SortDirection attribute that specifies the direction of the order.

Name : An ST_LongString attribute that specifies one column (1) from the input source specified by the Source attribute. If the column (1) is included in the query Results, then the data from that column (1) is ordered in the query Results. If the column (1) is not included in the query Results, then the ordering is applied as if the column (1) were included.

Source : An ST_ObjectName attribute that specifies the name or alias of one of the input sources to the query. The input source MUST be listed in the References collection of the query. If the Reference element specifying the input source specifies an Alias, then this attribute MUST use that value.

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

 <xsd:complexType name="CT_Order">
   <xsd:attribute name="Name" type="ST_LongString" use="required" wbld:cname="Name"/>
   <xsd:attribute name="Source" type="ST_ObjectName" use="required" wbld:cname="Source"/>
   <xsd:attribute name="Direction" type="ST_SortDirection" default="Ascending" wbld:cname="Direction" use="optional"/>
 </xsd:complexType>

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