Share via

2.2.3.20 CT_Query

  • Article

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

Referenced by: CT_AccListComboBoxRowSource, CT_ForEachRecordData, CT_LookupRecordData, CT_RecordSource, Query

Specifies a Query.

Child Elements:

Joins : A CT_Joins element that specifies all joins in the query.

Ordering : A CT_Ordering element that specifies the order of the query results.

Parameters : A CT_Parameters element that specifies all parameters in the query.

References : A CT_References element that specifies all input sources for the query.

Restriction : A CT_Expression element that specifies a filter for the query. All rows included in the query results MUST meet the criteria defined by the restriction expression.

Results : A CT_Results element that specifies the columns (1) included in the result of running the query.

Attributes:

Caption : An ST_LongString attribute that specifies a caption for the query.

MinimumClientDesignVersion : An Ignored Value.

Name : An ST_ObjectName attribute that specifies the name of the query. MUST be present when this query is not embedded in another object, such as a Macro or Form. MUST NOT be present when this query is embedded in another object.

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

 <xsd:complexType name="CT_Query">
   <xsd:sequence>
     <xsd:element name="Parameters" minOccurs="0" type="CT_Parameters" wbld:cname="Parameters"/>
     <xsd:element name="References" type="CT_References" wbld:cname="References"/>
     <xsd:element name="Results" type="CT_Results" wbld:cname="Results"/>
     <xsd:element name="Joins" minOccurs="0" type="CT_Joins" wbld:cname="Joins"/>
     <xsd:element name="Restriction" type="CT_Expression" minOccurs="0" wbld:cname="Restriction"/>
     <xsd:element name="Ordering" minOccurs="0" type="CT_Ordering" wbld:cname="Ordering"/>
   </xsd:sequence>
   <xsd:attribute name="Name" type="ST_ObjectName" wbld:cname="Name" use="optional"/>
   <xsd:attribute name="Caption" type="ST_LongString" wbld:cname="Caption" use="optional"/>
   <xsd:attribute name="MinimumClientDesignVersion" type="ST_ShortString" wbld:cname="MinimumClientDesignVersion" use="optional"/>
 </xsd:complexType>

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