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.
  • It could be done,with the page in edit mode,expand the Content Query Web Part menu and select Export and save the web part to te local file syatem.
  • Secondly,build the CAML required to filter the list.
  • Now update the QueryOverride property.
  • If I need four filters (one for each custom column) I could use the following value in the QueryOverride property:
     <property name="QueryOverride" type="string">
                           <FieldRef Name='NewColumn1' />
                           <Value Type='Text'>NewColumn1 Item1</Value>
                           <FieldRef Name='NewColumn2' />
                           <Value Type='Text'>NewColumn2 Item1</Value>
                           <FieldRef Name='NewColumn3' />
                           <Value Type='Text'>NewColumn3 Item1</Value>
                           <FieldRef Name='NewColumn4' />
                           <Value Type='Text'>NewColumn4 Item10</Value>
  • Finally ,Import the webpart to the webpart page.
  • With the web part page in Edit Mode, click the Add a Web Part link to open the Web Part Pane.
    Under the Upload a Web Part section select the modified web part file in the local file system and click Upload. This will load your web part under the Imported Web Parts category. Select your web part and click Add to import the web part into the web part page.


    There could be a chance that some of the elements in the UI getting disabled ,when we try to use the overrides property within the CQMP.In this case we cannot add more than three queries from Content Query Tool part.


Friday, July 12, 2013

Sharepoint 2103 Software and Hardware prerequisites

This article speaks about the software and hardware requirements for various kinds of installation scenarios supported by sharepoint 2013.Sharepoint 2013 provides the following installation scenarios.

Different Installation scenarios:
  1. Single server with built-in database
  2. Single-server Farm and
  3. Multiple server Farm installations
Software Requirements:
  • Windows Server 2008 R2 SP1 (KB 2759112)
  • Windows Server 2012 (KB 2765317)
  • Microsoft .NET Framework version 4.5
  • Either 64-bit edition of Microsoft SQL Server 2012 or 64-bit edition of SQL Server 2008 R2 Service Pack 1
Hardware Requirements:
  • 64-bit, 4 cores for small deployments (fewer than 1,000 users)
  • 64-bit, 8 cores for medium deployments (between 1,000 to 10,000 users)
  • 8 GB for small deployments (fewer than 1,000 users)
  • 16 GB for medium deployments (between 1,000 to 10,000 users)
Hard Disk:
  • 80 GB for System Drive and it also depends upon the amount of content you have in your deployment


Wednesday, July 10, 2013

Sharepoint2013 vs Sharepoint2010 Features

Hi everybody,it has been so long i have posted due to some unforeseen reasons.Anyway i have come back with a fresh information regarding sharepoint. Sharepoint 2013, the latest version , and the moment it was released there are lot of queries outbursting regarding all the features compared to the former edition ie sharepoint2010.Many users upgrading to the 2013 edition from 2010 had raised many questions in which most of thhem pointed to the feature comparison.So i wolud like to make you aware of some of the features which are enhanced ,upgraded or which made ease in sharepoint 2013 compared to thaose of sharepoint 2010 edition.
  • Making you very clear ,The structures of both the versions are same.So metadata architecture for documents in sharepoint2010 could definitely upgrade to the nwewr version sharepoint2013.
  • There are two utilities which made significant upgrades in document management which boosted the user experience
    1. Sharepoint 2013 included a drop and drag option to upload documents.
    2. It also made able to edit managed metadata in a datasheet view.
  • Lot of improvement has been done in 'search' option.
  • One of the major differences you could notice are in the 'Social Experiences'.The discussion boards feature in sharepoint 2013 is enabeled with Community features.This featues creates an engaging facebook like activity flow which made it feel more user-friendly when ccompared with the same feature present in sharepoint2010.
  • Generally sharepoint 2010 hosted a bit effort and planning for the networks while using the option "who you know" option ,which was made easy by the feature discussion boards employed in sharepoint 2013.