Share via

2.2.5.5 AccountingQueryCondition Element

  • Article

The AccountingQueryCondition XML element is used to specify a query on the accounting database. It is the root element of XML documents that are used in WSRM method parameters.

 <xs:element name="AccountingQueryCondition">
   <xs:complexType>
     <xs:sequence>
       <xs:element name="SelectFieldCollection">
         <xs:complexType name="SelectFieldCollection">
           <xs:sequence>
             <xs:element name="Column"
               type="xs:string"
               maxOccurs="unbounded"
              />
           </xs:sequence>
         </xs:complexType>
       </xs:element>
       <xs:element name="GroupColumnCollection">
         <xs:complexType name="GroupColumnCollection">
           <xs:sequence>
             <xs:element name="Column"
               type="xs:string"
               maxOccurs="unbounded"
              />
           </xs:sequence>
         </xs:complexType>
       </xs:element>
       <xs:element name="OrderColumnCollection">
         <xs:complexType name="OrderColumnCollection">
           <xs:sequence>
             <xs:element name="OrderInfo"
               maxOccurs="unbounded"
             >
               <xs:complexType name="OrderInfo">
                 <xs:sequence>
                   <xs:element name="Column"
                     type="xs:string"
                     maxOccurs="unbounded"
                    />
                   <xs:element name="IsAscending"
                     type="xs:unsignedByte"
                    />
                 </xs:sequence>
               </xs:complexType>
             </xs:element>
           </xs:sequence>
         </xs:complexType>
       </xs:element>
       <xs:element name="WhereClause"
         type="xs:string"
        />
       <xs:element name="HavingClause"
         type="xs:string"
        />
     </xs:sequence>
   </xs:complexType>
 </xs:element>

Child Elements

Element

Type

Description

SelectFieldCollection

SelectFieldCollection

A specification of a collection of field selections for an accounting database query.

Column

xs:string

The column names of the fields to select.

GroupColumnCollection

GroupColumnCollection

A specification of a collection of column groupings for a data query.

Column

xs:string

The column names of the fields to group.

OrderColumnCollection

OrderColumnCollection

A specification of a collection of column orderings for a data query.

OrderInfo

OrderInfo

A specification of a column ordering.

Column

xs:string

The column names of the fields to order.

IsAscending

xs:unsignedByte

The sort order, expressed as a Boolean value (section 2.2.2.1).

WhereClause

xs:string

Conditions to filter the data in the result set of the query.

HavingClause

xs:string

Conditions to filter the data in the result set of the query. This element SHOULD be used only with the <GroupColumnCollection> element.

The <WhereClause> and <HavingClause> elements are used as WHERE and HAVING clauses, respectively, of SQL stored procedures. They SHOULD follow SQL format, except that ("\n") SHOULD be used instead of apostrophe ("'").

For example:

  
 [ComputerName] = N\nNISWIN7AMD3\n AND [ProcessName] LIKE N\n%A%\n
 

"N" is needed for Unicode [UNICODE] support.

Additional XML data formats are specified in section 2.2.5.