Query Join between related lists in SharePoint 2010 using "SPQuery.Joins" property

One of the famous complains of the developers who switched from SQL background (For example Me :-)) to SharePoint development; is how to query related lists with joins instead on looping and filtering both of them using different queries.
You can Achieve this using the SPQuery.Joins Property.
Example:

Source: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spquery.joins%28v=office.14%29.aspx

PDF Documents Collaboration with SharePoint 2010

SharePoint 2007/ 2010 mainly used for documents management and collocation; including all the features (Check In, Check Out, Version History, etc...)  using Microsoft Office Suite. By default SharePoint does not support these features for PDF files. Adobe has released a product called Adobe Acrobat X which you can use it to achieve a good integration with SharePoint and use all its features Check In, Check Out, and Collect Feed back workflows. The following screenshots show some of its features [1].

  

Figure (1)  Open and Check out file

 

 

Refrences:

[1] http://pdfdevjunkie.host.adobe.com/pdf/AcrobatXandMicrosoftSharePoint.pdf

"Insert Related List" feature in SharePoint 2010

 One of the helpful features in SharePoint 2010 is the "Related List" button.

Figure(1)

This button is used to add lists which are related to a specific list (one-to-many relationship) in the same page and filter the data according to the selected item in the primary list.
Example: In this example I’ll present a demo for Customers and Customer Orders, and how to relate the data and display it in one page.
1- Create the following two lists:

• Customers:

Figure(2) Customers List

• Customer Orders:

Figure(3)  Customer Orders

Where the Customer field is a lookup from Customers list.

2- Enter some data to both lists.

3- Browse to a SharePoint page and add Customers List web part to it.

 

Figure(4)

4- In the Page Edit Mode; Activate the Customers web part by Selecting it.

Figure(5)

5- Clicking on “Insert Related List” shows all the lists which are related to the Customers list.
6- Select Customer Orders.
7- Now you will see that a new column “Select” has been added to the Customers web part and when the user clicks on it, it filters the list of orders by the selected customer.

Figure(6)

I hope this was useful for you.

If you have any comments don't hesitate to post it.

 

Create Site Action (SharePoint Designer 2010 Workflow Actions)

The actions can be downloaded here.

Add the “Create a Site” action to a SharePoint 2010 Designer Workflow

Configuration

URL: The url of the web site. You could either use an relative url to create the site direct under the current site or an absolute url to create the site under any site. The workflow initiator needs appropriate permissions. Or you can use an impersonation step to run the action under the permissions of the workflow author.
Title: Title of the site
Description: Description of the site
Template: Template name of the new site. Default is Team Site (STS#0).
You can get a list of all farm templates with the PowerShell command “Get-SPWebTemplates”.
To get a list of templates from a specific site’s template catalog use the following PowerShell command:
Get-SPWeb http://contoso/sites/spd | %{$_.GetAvailableWebTemplates($_.Language)}

Use the name of the template e.g. WIKI#0
Language Code: The language code for the new site e.g. 1033 for English or 1031 for German. 0 means inherit the language from the parent site.
Inherit Permission: Inherit permissions from the parent site.
Inherit Top Navigation: Use the same top navigation as the parent site.
Output: Returns the absolute url of the new site

Publish an run the workflow…

Source http://cglessner.blogspot.com/2011/02/create-site-action-sharepoint-designer.html

SharePoint 2010 Training Series

Microsoft is providing the following training series for both IT Professionals and Developers. I hope that it adds something new for you.

SharePoint 2010 Advanced IT Professional Training

• Core Architecture of SharePoint 2010
• Security in SharePoint 2010
• IT Pro Management in SharePoint 2010
• Upgrading to SharePoint 2010
• Enterprise Search in SharePoint 2010
• Content Management in SharePoint 2010
• Composite Solutions in SharePoint 2010
• Communities in SharePoint 2010
• Business Intelligence in SharePoint 2010
• SharePoint Online Overview

SharePoint 2010 Advanced Developer Training

• Developer Roadmap and Tools
• Core Development
• User Interfaces and Lists
• Data Access in Technologies
• Composite Solutions
• Enterprise Content Management
• Enterprise Search
• Business Intelligence
• Communities
• Development Life Cycle

SharePoint 2010 Branding Series

The following is a series of links for SharePoint 2010 Branding articles that goes step by step to implement the following design:

SharePoint 2010 Branding Series – Part One

SharePoint 2010 Branding Series – Part Two

SharePoint 2010 Branding Series – Part Three

SharePoint 2010 Branding Series – Part Four

SharePoint 2010 Branding Series – Part Five

The post will be updated periodically.

SharePoint 2010: Navigation Drop Down Styles

If you would like to stylize your navigation drop downs in SharePoint 2010 here are the 4 main key classes to update your CSS.
If you are looking for SharePoint 2007 styles see this blog post here.
The OOTB Navigation Drop Down CSS: “COREV4.CSS”

.s4-tn ul.dynamic{  
/* [ReplaceColor(themeColor:"Light2")] */ background-color:white;  
/* [ReplaceColor(themeColor:"Dark2-Lighter")] */ border:1px solid #D9D9D9;  
} 

.s4-tn li.dynamic > .menu-item{  
display:block;  
padding:3px 10px;  
white-space:nowrap;  
font-weight:normal;  
} 

a:link{  
/* [ReplaceColor(themeColor:"Hyperlink")] */ color:#0072BC;  
text-decoration:none;  
} 

.s4-tn li.dynamic > a:hover{  
font-weight:normal;  
/* [ReplaceColor(themeColor:"Light2-Lighter")] */ background-color:#D9D9D9;  
}

---

Example (Not good design, but you get the point)
/* Drop Down: Container Style */

.s4-tn ul.dynamic{  
background-color:white;  
border:3px dashed #000;  
}  
/* Drop Down: Item Padding Style */   
.s4-tn li.dynamic > .menu-item{  
padding:10px 20px 10px 20px;  
}  
/* Drop Down: Hyperlink Styles */   
.s4-tn li.dynamic > a{  
font-size: 9pt;  
font-weight:normal;  
color:#000;  
}  
/* Drop Down: Hyperlink Hover Style */   
.s4-tn li.dynamic > a:hover{  
font-weight:bold;  
background-color:#0C0;  
color:#FFF;  
}

What it will look like:

Simply take the above 4 main CSS classes and add/edit/delete the properties to make your drop down style truly unique."

Source:
http://erikswenson.blogspot.com/2011/02/sharepoint-2010-navigation-drop-down.html

The User Profile Synchronization service does not start on a stand-alone installation of SharePoint Server 2010

SharePoint Server 2010  has two installation options:
1- Complete Installation:
     You can add more Web Front End Servers,  Application Services Servers, and DataBase servers to your
    farm.
2- Stand-alone Installation:
    This installs all the components of SharePoint on one server, and you don't have the possibility to join more
     servers to the Farm.

One of the limitations of Stand-alone Scenario is:
"The User Profile Synchronization service is not designed to work on a stand-alone installation of SharePoint Server 2010."

Source:
http://support.microsoft.com/kb/983061

Configuring My Site in SharePoint 2010

The following article explains how to configure My Site in SharePoint 2010.
http://sharepointgeorge.com/2010/configuring-my-site-sharepoint-2010/

Multilingual user interface overview (SharePoint Server 2010)

Dears,
I found the following article from MSDN which explains

• Use and benefits of the multilingual user interface
  
  
• How the multilingual user interface works
  
  
• What is supported by the multilingual user interface
  
  
• Adding and modifying application content
  
  
• Exporting and importing translated content
  
  
• Using the multilingual user interface with managed metadata
  
  
• Limitations of the multilingual user interface 

http://technet.microsoft.com/en-us/library/ff805062.aspx#Section2 

New SharePoint Developer Features in VS2010 SP1 – Unit Testing and IntelliTrace (Saaid Khan)

As part of VS 2010 SP1 SharePoint developers can now take advantage of IntelliTrace as well as create unit tests that use SharePoint API’s.

With 64-bit support now enabled in IntelliTrace, you can use IntelliTrace in your SharePoint farm solutions. You can set a break-point in your code or break execution and then view the IntelliTrace data. You can also collect IntelliTrace data and save the .itrace log file for viewing at a later time. Check out Justin Marks great article on IntelliTrace in VS2010.

For those SharePoint developers that create unit tests, you can now create and execute unit tests for your SharePoint 2010 solutions if they use SharePoint API’s. In order to execute these unit tests you first need to deploy your SharePoint solution to your local developer machine. After that, you can execute the unit tests as you would normally.

Source