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>