Dynamically assemble CAML to call related List Items?

Question

I have good methods in place to get my core List of Posts. Let's say I get the 100 most recent Posts.

I'd like to get all comments related to those posts. Comments have a field called PostID that stores the ID of the post they are on.

I could just get all comments, and loop through them, but that seems less than ideal.

I could call comments for each post, and get them with CAML, but that's a LOT of calls.

Is there a way to build a giant CAML statement to get all posts where PostID is contained in my list of 100 posts?

Russell · Accepted Answer · 2012-08-10 03:00:21Z

You can use Linq and XElement objects to dynamically build your Caml query.

In the past, to use the "contains" clause, I have done something like the following:

public string GenerateCaml(List<int> Ids)
{
  XElement root = new XElement("And");
  foreach(int id in Ids)
  {
    root.Add(new XElement("Or",
                new XElement("Eq",
                   new XElement("FieldRef",
                     new XAttribute("Name", "ID")),
                   new XElement("Value",
                     new XAttribute("Type", "Text"),
                     id.ToString()) ) );

  }
  return root.ToString();
}

Ashish Patel · Accepted Answer · 2012-08-10 02:34:10Z

0

If you are willing to use LINQ to SharePoint, following article should help you. It covers the lookup columns at good length and also gives you examples of the CAML queries:

http://msdn.microsoft.com/en-us/library/ff798478.aspx

answered Aug 10, 2012 at 2:34

Ashish Patel

11.4k3 gold badges24 silver badges29 bronze badges

Add a comment |

Stack Exchange Network

Dynamically assemble CAML to call related List Items?

2 Answers 2

Hot Network Questions

Dynamically assemble CAML to call related List Items?

2 Answers 2

Related

Hot Network Questions