Showing posts from March, 2012

How to use Content Query Webpart in SharePoint

In this article I would detail more on how to use Content query webpart in SharePoint 2010, it has got a bit more enhanced and advanced than the CQWP (content query webpart) you found in SharePoint 2007; however you can easily get wrong on understanding how this works because of several reasons.
I had spent time looking around  and wasting a lot of time to find articles on this, so I thought better to put together all these in a single place for you all...

If you search for CQWP mostly you would hit the MSDN site however you still might need to find other articles to understand it and  get a grip. The primary question is …..

      Q. Where do you use a CQWP, and basically When will you use this webpart?

Ans.      Content Query Web Part could be used to create custom views of data that is queried from many sources, and present that data all in one place. After you add the Content By Query Web Part to a Web page, you can customize the Web Part's querying behaviours  and also the lo…

Unable to Display List in SharePoint Page

You would have got an error something similar to this, at least once in your sharepoint journey ...

"The page you selected contains a list that does not exist. It may have been deleted by another user"
This is primarily happening because of a reference missing or corrupted webpart, So quick tip to get out of this situation first:

Step 1. Try and find which list is causing the issue, so get to the SharePoint maintanence page
if you append "?contents=1" to your site URL you will get into the maintanence page
Eg. ?contents=1

Step 2. Once the webpart is removed try and scope where the problem is, you can use SharePoint logs for this.

I thought of jotting this out, as a quick pointer in panic mode....

How to show a column value based on other columns in a SharePoint Custom List

In one of the SharePoint list i was asked to provide a custom value based on the values inputed on the other columns. You might have faced a similar situation sometimes, this was thought to be a customisation, but i found that this could easily be acheived by using formula column in SharePoint.

I would run through the steps here : Column 1 Column 2 Column 3 (Formula Column) Value 1 Value 2 If Value in both Columns =”OK” If  No Values in both columns =”Not Applicable”  Value 1  Value

So if Column1 and 2 has both values then Column 3 value = "OK" else "Not Applicable"
I tried couple of variations and was able to find a solution for this using the formula below : =IF(COUNTA([Column 1],[Column 2])=0, "Not Applicable", "OK")
Step 1. Create a new column in a list Step 2. Select the "Type of Information as" : Calculated (calculation based on other columns)
Step 3.
In the Formula column insert the appropriate columns and add the formula (you may have to edit t…