Understanding Dynamic queries
How To Write Dynamic CAML : While writing CAML query, you must understand the architecture how it works. It is pretty simple. You just have to do logical AND/OR operators. Any operator must have 2 conditions to combine and test. SCENARIO 1 : This is 1 Operator use with 2 conditions <Or>
<Eq>
<FieldRef Name='Status' />
<Value Type='Text'>StatusVal1</Value>
</Eq>
<Eq>
<FieldRef Name='Status' />
<Value Type='Text'>StatusVal