CAML Query parameter equals string

camlsharepointsharepoint-2007sharepoint-2010

I have the following CAML Query. What I need in it is another clause that tests for the string "0 – 9" is equal to {ToyotapediaCharacterSelector} and if not go into the existing .

Can anyone help please?

    <Query>
      <Where>
        <And>
          <Eq>
            <FieldRef Name='MyCategories' />
            <Value Type='Text'>{MyCategories}</Value>
          </Eq>
          <BeginsWith>
            <FieldRef Name='Title' />
            <Value Type='Text'>{MyCharacterSelector}</Value>
          </BeginsWith>
        </And>
      </Where>
    </Query>

Best Answer

Using a calculated column will allow you to determine if the content in your column is numeric or text. You can then use this as a filter in your view

Related Solutions

SharePoint CAML Query AND/OR operators

Query:

<Query>
   <Where>
      <And>
         <Eq>
            <FieldRef Name='ID' />
            <Value Type='Counter'>1</Value>
         </Eq>
         <And>
            <Eq>
               <FieldRef Name='Department' />
               <Value Type='Choice'>Audit</Value>
            </Eq>
            <Or>
               <Eq>
                  <FieldRef Name='Status' />
                  <Value Type='Choice'>In Progress</Value>
               </Eq>
               <Eq>
                  <FieldRef Name='Status' />
                  <Value Type='Choice'>Not Started</Value>
               </Eq>
            </Or>
         </And>
      </And>
   </Where>
</Query>

Note: it is assumed that Department is a Choice field

I would recommend you to utilize the tool that will help you build your CAML Queries, for example U2U Caml Query Builder

enter image description here

Best Answer

Related Solutions

SharePoint CAML Query AND/OR operators

Related Topic