1 out of 2 rated this helpful - Rate this topic

Contains Element (Query)

Windows SharePoint Services 3

SharePoint 2010

Searches for a string anywhere within a column that holds Text or Note field type values.

Copy


<Contains>
  <FieldRef Name = "Field_Name"/>
  <Value Type = "Field_Type"/>
  <XML />
</Contains>

Attributes

Attribute	Description
None	N/A

And, Or, Where

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".

XML

Copy

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>";
}

Other Resources

BeginsWith Element (Query)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

Can the field value be a subset of the Value element?

I have tried a CAML query like the following:

<Where>

<Value Type="Text">SomeDataHere</Value>

</Contains>

</Where>

Unfortunately, it doesn't work. Is there a reason why it shouldn't work this way?

Thanks

History

1/20/2010
h_chin

How to implement "ignore case" for Contain

I wanna implement a caml query like:

<where>

Key

</Value>

</Contains>

</where>

If i wanna ignore the case, ex. i wanna search all the items whose title contain "key" or "Key" or "KEY" or...

Does CAML support it?

PS: Same condition when i search "e" but i have many é,è,ê in my items.

History

10/9/2009
JackieLee