Multiple Values in CAML query from Array? SharePoint 2010 using jQuery/SPServices

Question

So if I use SPServices to GetListItems with CAMLQuery, is it possible to insert multiple values inside Value Type='Number'> here

I would like to evaluate things throught a flow in my page, add to an array, and then query using SPServices. Do I have to create a string for each value from the array, and do like a CAMLQueryString += string from .each value of array, and then CAMLQuery = CAMLQueryString inside the SPServices options kind of thing?

Perhaps this is a CAML question, or an SPServices question? I am not really sure.

Thanks Justin

Answer 1

It is more a caml question than an SPServices question.

Often one uses or and and operators to combine multiple values, which, like @rjcp3 said, can be messy.

There is another operator, less known, IN operator to choose a range of values (see the xml example below).

To simplify the creation of CAML queries in javascript, I'd recommend SharePoint EcmaScript Caml Builder - an open source javascript library released under the Ms-PL licence on codeplex. Creds go to omlin.

Here is an example from camljs.codeplex.com:

caml = camlBuilder.Where()
    .LookupIdField("Category").In([2, 3, 10])
    .And()
    .DateField("ExpirationDate").LessThanOrEqualTo("{Now}")
    .OrderByDesc("ExpirationDate")
    .ToString()

This results in the following CAML query which you can put into a SPServices request:

<Where>
  <And>
    <In>
      <FieldRef Name="Category" LookupId="True" />
      <Values>
        <Value Type="Integer">2</Value>
        <Value Type="Integer">3</Value>
        <Value Type="Integer">10</Value>
      </Values>
    </In>
    <Leq>
      <FieldRef Name="ExpirationDate" />
      <Value Type="Date">
        <Now />
      </Value>
    </Leq>
  </And>
</Where><OrderBy>
  <FieldRef Name="ExpirationDate" Ascending="False" />
</OrderBy>

Answer 2

You can't add multiple values directly to one node, but you can add multiple <Or> or <And> elements (it just gets a little messy with complex statements).

Answer 3

I create similar dynamic CAMLQueries in SPServices itself. As much as people say they hate CAML, the reverse notation makes it relatively easy to build fairly complex queries programmatically. If you take a look at the way I build the CAMLQuery for the GetListItem query in SPCascadeDropdown to populate the child column, especially where the parent is a multi-select, you'll get the idea.

Answer 4

Hard to say exactly what you are asking but I am guesing you need to construct a CAML query with a series of numbers, like a SQL "In" operator.

SharePoint 2010 has a CAML In operator, which is documented here: In element (Query).

In the Community Content section at the bottom, a user has inserted a code example. is this what you're looking for?