Filter CAML Query by List Item ID in SharePoint Online/2013/2016

This SharePoint CAML tutorial explains, how to retrieve list items from SharePoint Online/2013/2016 based on ID. We will see how to filter the CAML query by list item ID in SharePoint Online or SharePoint 2016/2013.

In SharePoint, the best approach to get the data from SharePoint a list is to query those using either the SharePoint Server Object model or the client object model. Using queries you guarantee that only list items you really need are retrieved from the database and constructed to objects by SharePoint.

Most of the time you don’t need the full collection of list items, so it does not point to ask all the items and then use only a few of these. Let’s see how we can query SharePoint lists using the Client object model.

CAML query to find an item from a SharePoint 2013 List based on the “ID” value that is being retrieved through JavaScript SharePoint web service interface Lists.asmx that provides a set of simple remote methods calls ID Type deprecated in 2013.

SharePoint 2010 (caml query to retrieve sharepoint list item by ID)

Below is the CAML query to retrieve the list item by ID in SharePoint 2010.

<Query><Where><Eq><FieldRef Name="ID" /><Value Type="Counter ">' + ID + '</Value></Eq></Where></Query>

SharePoint 2013/Online (caml query to retrieve sharepoint list item)

Below is the CAML query to retrieve list items by ID in SharePoint 2013/Online.

<Query><Where><Eq><FieldRef Name="ID" LookupId="TRUE"/><Value Type="Text">' + ID + '</Value></Eq></Where></Query>

I am using an ajax / Jquery script calling the getlistitems() method to filter the results using a query in SharePoint.

Use the following procedure to create a sample.

Step 1: Navigate to your SharePoint 2013 site.

Step 2: From this page select Site Actions | Edit Page:

Edit the page, go to the “Insert” tab in the Ribbon and click the “Web Part” option. In the “Web Parts” picker area, go to the “Media and Content” category, select the Script Editor Web Part and press the “Add button”.

Step 3: Once the Web Part is inserted into the page, you will see an “EDIT SNIPPET” link; click it. You can insert the HTML and/or JavaScript as in the following:

Script:

<script src="/Style%20Library/Scripts/jquery-1.10.1.min.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function () {
findtext(8);
});
function findtext(id) {
var soapEnv =
"<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'> \
<soapenv:Body> \
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>companyInfo</listName> \
<query><Query><Where><Eq><FieldRef Name='ID' LookupId='TRUE'/><Value Type='Text'>"+id+"</Value></Eq></Where></Query></query>\
<viewFields> \
<ViewFields> \
<FieldRef Name='Company' /> \
</ViewFields> \
</viewFields> \
</GetListItems> \
</soapenv:Body> \
</soapenv:Envelope>";
$.ajax({
url: " /_vti_bin/Lists.asmx",
type: "POST",
dataType: "xml",
data: soapEnv,
complete: processResult,
contentType: "text/xml; charset=\"utf-8\""
});
}

function processResult(xData, status) {
$(xData.responseXML).find("z\\:row").each(function () {
var companyName = $(this).attr("ows_Company");
$('#ResultDiv').html(companyName);
});
}
</script>

Final O/p:
Amazon.com

You may like following SharePoint CAML Query examples:

• How to Use CAML Query for Boolean field for SharePoint 2013/2016/Online Object Model CSOM
• Download, Install and Use CAML Query Helper in SharePoint Online/2013/2010/2007
• Caml query builder SharePoint 2013 Online
• CAML Query Builder for SharePoint 2013/2016/Online
• CAML Query filter by date range is not working in SharePoint 2013 JavaScript client object model
• SharePoint CAML Query Order by Example with Dropdown in SharePoint Online/2013/2016
• Task assigned to user or current user groups in SharePoint 2010 using CAML query

In this article, I have explained in detail, how to retrieve List items from SharePoint 2013 based on the “ID” column value using CAML Query.