Join Robert Bogue for an in-depth discussion in this video Querying with CAML, part of Developing SharePoint Full Trust Solutions for SharePoint 2013.
- Now that we know how to get an entire list,…how do we get only the records we want with CAML?…CAML is very high performance…and you can even use CAML queries,…like we'll show you here,…to get data from BCS or Business Connectivity Services,…basically, any kind of external data that you can query…you can get through CAML.…There are a large number of side effects…when working with CAML.…You'll see probably two different things.…The first is, is that queries will return zero results.…
You'll feel like you're stuck…and trapped with no way to get out.…The next thing that you can sometimes get…is an SPException that just basically says,…"Invalid exception."…Well, that doesn't mean anything to most people.…It's kind of useless.…So, CAML, though it's very powerful and high performance,…will take a little bit of getting used to.…It means that capitalization has to be perfect.…It means that field names…have to match the internal names exactly.…And it's a little particular.…
But once you can get a couple of queries down,…
If you've wanted to learn how to develop custom solutions on SharePoint—or you've been told that you need to develop a solution that integrates with SharePoint—this is the training you need. It's quick, to the point, and effective at helping new developers work with SharePoint code.
Robert Bogue shows how to create new web parts, access and update data in SharePoint, work with files, and create SharePoint artifacts: lists and libraries to store data, site-level features, files, etc. He also shows how to create sandbox solutions that do not affect the rest of the server environment, and discusses execution options for solutions, including in-page, quasi-page, and out-of-page execution.
- Developing a web part
- Connecting and configuring web parts
- Building sandboxed code
- Choosing an access method for SharePoint data
- Querying with CAML
- Fetching files
- Updating SharePoint data
- Creating and provisioning artifacts
- Executing long-running operations
- Tinkering with timer jobs
- Understanding SharePoint execution workflow