Land and Water Boards of the Mackenzie Valley

CAML Help

Collaborative Application Markup Language (CAML), based on XML language, is used in defining sites and lists, including fields, views, or forms in Microsoft� Windows� SharePoint� Services. For more information on CAML, see the MSDN article Introduction to Collaborative Application Markup Language (CAML).

CAML can be used in a number of ways, but in the Bamboo List Rollup Web Part, it is mainly used for defining front-end list or view definitions. For example, when selecting lists or views to include in a List Rollup, you may want to filter the list or view for use in a List Rollup data view. Some examples for implementing a CAML filter are as follows:

� To filter a list or view so users only see data where Status is equal to �Not Started�, type the following:

<Where>
    <Eq>
        <FieldRef Name='Status' />
        <Value Type='Choice'>Not Started</Value>
    </Eq>
</Where>

� To filter a list or view so users only see data where Priority is equal to �High� and Status does not equal �Completed�, type the following:

<Where>
    <And>
        <Eq>
            <FieldRef Name='Priority' />
            <Value Type='Choice'>(1) High</Value>
        </Eq>
    <Neq>
        <FieldRef Name='Status' />
        <Value Type='Choice'>Completed</Value>
    </Neq>
    </And>
</Where>

To download and install a free tool that enables you to build CAML filters quickly and easily, go to U2U CAML Query Builder for SharePoint 2003.

Applying a CAML filter to a list or view is entirely optional. You can always filter the list or view in SharePoint to suit your needs prior to including it in the List Rollup data view.