ColumnSet XML Schema

This is a parameter that is passed into many API methods that retrieve data from the Microsoft CRM database. The following describes the schema for this parameter:

ColumnSetXml := 
   <columnset
      (page='page-number')? 
      (count='items-per-page')? >
      ( ColumnXml | OrderXml | FilterXml ) *
   </columnset>

ColumnXml := 
   <column>column-name</column>

OrderXml := AscendXml | DescendXml

AscendXml :=
   <ascend>column-name</ascend>

DescendXml :=
   <descend>column-name</descend>

FilterXml := NullFilterXml | SingleFilterXml | MultipleFilterXml

NullFilterXml :=
   <filter
      column='column-name' 
      operator=('null' | 'not-null') />

SingleFilterXml :=
   <filter
      column='column-name' 
      (attribute='attribute-name')?
      operator=('eq' | 'neq' | 'like' ) 
      value='value-data' />

MultipleFilterXml :=
   <filter
      column='column-name' 
      (attribute='attribute-name')?
      operator='in' 
      value='(value-data)(,value-data)+' />

The following table shows the valid operators for filter.

© 2005 Microsoft Corporation. All rights reserved.