Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We are trying to create SPAlert programatically in Sharepoint 2007 portal, but we are encountering an issue while creating CAML query for eight parameters to filter. The e-mail is getting triggered for filter on one/two parameters.

Below is the CAML query for eight parameters, not sure what I am doing wrong.

    <Query>
    <Or>
      <Or>
       <Eq><FieldRef Name='consulting' /><ValueType='Text'>cbYes</Value></Eq>
       <Or>
         <Eq><FieldRef Name='consulting1' /><Value Type='Text'>cbNo</Value></Eq>
         <Or>
          <Eq><FieldRef Name='tags' /><Value Type='Text'>strTags</Value></Eq>
          <Eq><FieldRef Name='domain' /><Value Type='Text'>strDomain</Value></Eq>
         </Or>
      </Or>
     </Or>
      <Or>
       <Eq><FieldRef Name='consulting' /><ValueType='Text'>cbYes</Value></Eq>
     <Or>
      <Eq><FieldRef Name='stype' /><Value Type='Text'>strContentSubType</Value></Eq>
         <Or>
            <Eq><FieldRef Name='vertical' /><Value Type='Text'>strSubVertical</Value></Eq>
            <Eq><FieldRef Name='account' /><Value Type='Text'>strAccount</Value></Eq>
         </Or>
     </Or>          
    </Or>
</Or>
    </Query>
share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.