CAML Query that filters against a Lookup Column

<Where>
    <Eq>
        <FieldRef Name=”Category” />
        <Value Type=”Lookup”>My category</Value>
    </Eq>
</Where>

By ID:

<Where>
    <Eq>
        <FieldRef Name=”Category” LookupId=”TRUE” />
        <Value Type=”Lookup”>1234567</Value>
    </Eq>
</Where>

Comments

Post a Comment

Popular posts from this blog

Change SharePoint Site Time Format

Image
In SharePoint calendar by default we can see the view as Day/week in 12 hour format, not in 24 hour format. We can to change the format from 12 hour to 24 hour through UI or using Power Shell commands. We can change that through UI by following steps, Navigate to SharePoint Site settings page and in Site Administration section click on “Regional settings” link In Time format drop down select 24 hour format. Click on ok to save the settings. We can change the format using following Powershell commands, $site = Get-SPSite <SiteCollectionURL> $web = $site.OpenWeb() $web.RegionalSettings.Time24=$True $web.RegionalSettings.FirstDayOfWeek=1 $web.Update() $web.Dispose() $site.Dispose()
Read more

Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException", SharePoint exception after applying cumulative update\service pack

After applying a cumulative update on one of my SharePoint server, tried to run configuration file using psconfig.exe -cmd upgrade -inplace b2b -wait -force command, i got an error saying that "Exception: Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: An upgrade conflict has occurred and you must re-try this action" We can fix this exception by setting line-update-running property to true. To do that Open command prompt with administrator privileges and navigate to bin folder (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Bin) and execute following command stsadm -o setproperty -pn command-line-upgrade-running -pv Yes By running this command on SharePoint server, it will reset the command-line-upgrade-running property. We need to execute this command on all the SharePoint servers in the farm after upgrading. Once we are done with running this command, we have to run config command as psconfig.exe -cmd upgrade -inplace b2b –wai...
Read more

Get list of all users in a site collection and get all the web parts in a page

We can get the list of all users and web parts in a page by entering the URL of the site with addition of text. We can get all the users by appending “_ layouts/people.aspx?membershipGroupId=0 ” text. We can get all the users in a Site collection. We can have settings for the list of the users. We can get the list of all web parts in a page by appending “ ?contents=1 ” text to Url of the site. It will navigate to SharePoint web parts maintenance page. We can have option to close the web parts, reset and delete the web parts from the page
Read more