Using the IN Operator in a CAML Query

The In operator is used in an SQL query allows you to specify multiple values in a
WHERE clause. The CAML query language also uses the IN operator, in place of using multiple ORs, to return multiple values of a column.

<In><FieldRef Name='Col1'/>
    <Values>
        <Value Type='Text'>A</Value>
        <Value Type='Text'>B</Value>
        <Value Type='Text'>C</Value>
    </Values>
</In>

Using PowerShell to downgrade a SharePoint v4 site to v3

Use the following powershell commands on a SharePoint front end server to downgrade a v4 site to v3.

$Web=Get-SPWeb http://<site name>/<site>

$Web.UIVersion=3

$Web.UIVersionConfigurationEnabled=$true

$Web.update()

Using the Eval method in a SharePoint master or layout page

Examples of using Eval method in SharePoint master or layout page:

In this example "Include Time" is a SP yes/no field where we're checking for a value of "yes":

<%# Eval("Include Time").ToString() == "True" ? " (" + Eval("Start Time","{0:hh:mm tt}") + ")" : "" %>

In this example "Active" is a SP yes/no field where it's casted to a boolean value and then used to control visibility of an asp:Label control:

Visible='<%# bool.Parse(Eval("Active").ToString()) %>'

Another example of setting the Visible property. If the value of Descrition is null, hide the control:

Visible='<%# bool.Parse(Eval("Description") == null ? "False" : "True") %>'

SubjectsAll dynamic prompt for Crystal

The prompt group 'RDS SubjAll M' in Crystal Reports requires logic in the Record Selection formula to account for the ' All' value for all subjects. Below is an example of how to construct the query:

if ({?Subject} <> " All") then 

({?Subject} = {RDS_CLASS_VW.CLASS_SUBJECT_CD} and

{?Institution} = {RDS_CLASS_VW.CLASS_INSTITUTION_CD})

else

{?Institution} = {RDS_CLASS_VW.CLASS_INSTITUTION_CD}

If the Subject parameter equals ' All' we simply ignore it.

Removing annoying checkboxes in a List web part

When I add a List web part to a page, I'm left with a bunch of annoying check boxes in front of each item, as shown below:

To get rid of these, since they don't really serve any purpose on our public pages, I've added a content editor web part to the page with the following css code. Make sure you add the code using the source editor:

<style type="text/css">

TH.ms-vh-icon {

DISPLAY: none

}

.ms-vb-itmcbx {

DISPLAY: none

}

</style>

I then get a cleaner look to the listing with the check boxes removed from the page.

Adding Javascript to a SharePoint Master or Layout page

If you need to add javascript to a SharePoint Master or Layout page, add the script to the Head section or PlaceHolderAdditionalHead content area. Be sure to include the  _spBodyOnLoadFunctionNames.push function so your function is added to the OnLoad method.

<script type="text/javascript">

function UpdateCampusAddress()

{

if (window.location.href.toLowerCase().startsWith("http://<site name>/"))

{

document.getElementById('CampusAddress').innerHTML = "Williams Campus";

}

else if (window.location.href.toLowerCase().startsWith("http://<site name>/"))

{

document.getElementById('CampusAddress').innerHTML = "Sun Lakes Campus";

}

}

_spBodyOnLoadFunctionNames.push("UpdateCampusAddress");

</script>

Empty dataset template for DataList control

There is no Empty dataset Template for the DataList control. To display a message in the DataList control if your dataset is empty, define a HeaderTemplate and set the visibility based upon the item count as shown below:

 

<asp:DataList runat="server" id="DataList1" DataSourceID="spDataSource1">

<HeaderTemplate>

<span style="font-style:italic;color:#181818">

<asp:Label ID="lblEmpty" Text="No Events" runat="server" Visible='<%# DataList1.Items.Count==0 %>'/>

</span>

</HeaderTemplate>

<ItemTemplate>

<p>

...

</p>

</ItemTemplate>

</asp:DataList>