Share via

2.2.3.2 CT_Order

  • Article

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

Referenced by: CT_Ordering

Specifies a single order to apply to a CT_Query (section 2.2.3.18).

Attributes:

Direction: An ST_SortDirection (section 2.2.4.7) attribute that specifies the direction of the order.

Name: An ST_LongString (section 2.2.4.4) attribute that specifies one column from the input source specified by the Source attribute. The column MUST be included in the CT_Results element (section 2.2.3.9) of the parent CT_Query (section 2.2.3.18). If the CT_Result (section 2.2.3.8) element specifying the column has an Alias attribute, then this attribute MUST have that value. The data from that column is ordered in the query CT_Results according to Direction.

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 parent CT_Query (section 2.2.3.18). If the CT_Reference (section 2.2.3.6) element specifying the input source has an Alias attribute, then this attribute MUST have 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.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).