Showing posts from February, 2014

SharePoint 2010 Content Query Web Part (CQWP) to display items from a List and Format it

In this article i will show how to query a SharePoint List using Content Query Webpart and display the results in a Nice formatted way
Here is a screenshot of what i have done using CQWP , querying a Custom SharePoint List:

I will explain the steps below on how i have accomplished this :

Step 1.
I have created a custom list with appropriate list columns and it has got columns with the names : “Contract Name” [Single Line of Text]  “Alert Date”[Date and Time] and “Notes” [Multiple line of Text].

Step 2.
Add a Content Query Webpart [CQWP] on to the site, now for displaying this in the above format we need to do two things
- Need to Edit the “ItemStyle.xslt” in the Styles folder and need to add a bit “CSS” on to the Site. Both of these can be accomplished as long as you have access to these folders and if you can add a Content Editor Webpart on to the page.
Now let me walk you through these two steps:
First lets see how we can edit the “Item Sytle.xl” file
Navigate to Site A…

How to filter SharePoint List based on user permission

Have you ever had a scenario where you had to create a custom list and then you should only show items in the list which the user is supposed to see based on the user permission or the User Group he belongs to?

Read on if you want to find a solution for this scenario..... I did tried lot of researching and I got bits and pieces of information scattered in the net but couldn’t find a compete article, so thought to blog it, hope this will help you.

I will brief a bit more on the scenario:

I was asked to create a Master Custom list for users of different departments in my company however since there are confidential documents these items should not be shown to each other. My initial thought was to achieve this OOB using views and permission however while digging down I understood that this was not straight forward and I couldn’t find much help from the internet. To achieve this I have done the below : 

Step 1.

First I have created a Custom list called “Contract Manager” with the necessary col…