Category: SharePoint 2010

Business Data Related List Webpart


Today I will discuss about how to configure Business Data Related List web part.

Business Data related list will be filtered as per the connected Business Data list webpart.

Ok then Let start.

1) Open your page in edit mode -> chose insert webpart and select Business Data List Web part. Now edit webpart and choose your External entity.

Here I have Chosen Project Entity.

2) Next add Business Data Related List Webpart and edit its property. Choose related entity. Here I have chosen Employee entity. Here you need to configure the Association method.  This entity should have association method.

The Relation between Employee and Project Entity is like Each Employee is assigned to a Project. Now We need to display all employees that are assigned to a particular project.

3) Make sure you have Allow Connection checked and the Business Data Relation List Web Part  connected with  Business Data List web part.

That’s it. We have configured our Business Data Related List webpart.

Enjoy..!! 🙂

SP2010 List View and CAML : Part 2

In Part 2; I will discuss about little complex scenario.

Let’s take an example that we have a Task List. Each task is assigned to an employee by “Assigned To” field. Each task has a DueDate set on it.

Now we need to make a view that only managers can view. This view should show all tasks those have their due date more than past 7 days.

By this view Manager can find all employees who have not completed their tasks. 😉

Hope That helps..!!

And your view will look like this:

How to hide/unhide list using SharePoint Designer 2010

How to hide a list in Designer:

In List settings-> General Settings

1)         Uncheck option “Display this list on quick launch”. [This is necessary]

2)         Check the “Hide from browser”.

3)         Save the list.

Open it SharePoint site in browser and check that your list is hidden now.

How to open hidden list and unhide it in Designer:

1)      Open SharePoint designer 2010.

2)      Click the “All Files” folder at the bottom in left pane.

3)      Right click your hidden list from “All Files -> Lists” folder and choose property.

4)      Now you have your hidden list open in SPD.

5)      In List settings-> General Settings: Uncheck the “Hide from browser” and save.