नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
Applies to: SharePoint 2016 | SharePoint Foundation 2013 | SharePoint Online | SharePoint Server 2013
Searches for a string anywhere within a column that holds Text or Note field type values.
<Contains>
<FieldRef Name = "Field_Name"/>
<Value Type = "Field_Type"/>
<XML />
</Contains>
Elements and attributes
The following sections describe attributes, child elements, and parent elements.
Attributes
None
Child elements
Parent elements
Occurrences
- Minimum: 0
- Maximum: Unbounded
Example
The following example uses the Contains element within a string that is assigned to the Query property to return the titles of items where the Conference column value begins with "Morning" and contains "discussion session".
SPWeb mySite = SPControl.GetContextWeb(Context);
SPList list = mySite.Lists["List_Name"];
SPQuery query = new SPQuery();
query.Query = "<Where><And><BeginsWith><FieldRef Name="Conference"/>" +
"<Value Type="Note">Morning</Value></BeginsWith>" +
"<Contains><FieldRef Name="Conference" />
<Value Type="Note">discussion session</Value>" +
"</Contains></And></Where>";
SPListItemCollection myItems = list.GetItems(query);
foreach (SPListItem item in myItems)
{
Label1.Text += item["Title"] + "<BR>";
}