2 people following this project (follow)

Project Description

Lets you create SharePoint CAML queries using T-SQL syntax.

Basically, it lets you write a query like this:

    	WHERE ContentType="My Content Type"
    	OR Description<>null
    	GROUPBY Title DESC
    	ORDERBY Author, AuthoringDate, AssignedTo ASC

and translate into

<Query>
  <Where>
    <Or>
      <Eq>
        <FieldRef Name="ContentType" />
        <Value Type="Text">My Content Type</Value>
      </Eq>
      <IsNotNull>
        <FieldRef Name="Description" />
      </IsNotNull>
    </Or>
  </Where>
  <Order>
    <FieldRef Name="Author" />
    <FieldRef Name="AuthoringDate" />
    <FieldRef Name="AssignedTo" Ascending="True" />
  </Order>
  <Group>
    <FieldRef Name="Title" />
  </Group>
</Query>

YACAMLQT_Sample_Gui.PNG

On Line version

test the online version at http://www.spsprofessional.com/sqlcaml.aspx

Información en castellano

Last edited May 27 2009 at 12:27 AM by csegura, version 5