Content Query Web Part ,Adding more than three filters:

Thursday, July 18, 2013

Content Query Web Part ,Adding more than three filters:

Even though people use CQWP to roll up content from their sites or subsites, they feel little awkward noticeing that the UI part of the tool support only three filters.
So i am here in this post with a simple solution.
One of the frequent ways to to allow filters more than three is to override the QueryOverride property of the webpart. Inorder to achieve this follow the following four simple steps:

Firstly,Webpart should be exported to the File system.

Secondly,build the CAML required to filter the list.
Now update the QueryOverride property.

 <property name="QueryOverride" type="string">
          <![CDATA[
           <Where>
              <And>
                 <And>
                    <BeginsWith>
                       <FieldRef Name='NewColumn1' />
                       <Value Type='Text'>NewColumn1 Item1</Value>
                    </BeginsWith>
                    <BeginsWith>
                       <FieldRef Name='NewColumn2' />
                       <Value Type='Text'>NewColumn2 Item1</Value>
                    </BeginsWith>
                 </And>
                 <And>
                    <BeginsWith>
                       <FieldRef Name='NewColumn3' />
                       <Value Type='Text'>NewColumn3 Item1</Value>
                    </BeginsWith>
                    <BeginsWith>
                       <FieldRef Name='NewColumn4' />
                       <Value Type='Text'>NewColumn4 Item10</Value>
                    </BeginsWith>
                 </And>
              </And>
           </Where>
          ]]>
        </property>