Stack Overflow
Stack Overflow

Questions tagged [caml]

CAML (Collaborative Application Markup Language) is an XML based markup language used with the family of Microsoft SharePoint technologies (Windows SharePoint Services and Office SharePoint Server). For the Objective Caml programming language, use the tag ocaml.

CAML (Collaborative Application Markup Language) is an XML based markup language used with the family of Microsoft SharePoint technologies (Windows SharePoint Services and Office SharePoint Server).

Not to be confused with Objective Caml, the current implementation of the Caml programming language. For Objective Caml, use the tag.

Unlike plain XML, CAML contains specific groups of tags to both define and display (render) data.

CAML query syntax can be created graphically from an existing SharePoint list by using the U2U CAML Generator tool.

For getting started with CAML, please visit its MSDN page.

644 questions
8
votes
4 answers

How to do double orderby in CAML Query?

I am using camel query in visual studio c# to get items from a list from sharepoint 2010. The list items has two fields that I want to use in the caml query. One is "Section" and the other is "Order By". The query needs to order the items in a…
omega
  • 40,311
  • 81
  • 251
  • 474
8
votes
4 answers

CAML "NOT IN" query

Is there a way to do something like "NOT IN" behavior in SharePoint 2010? I can easily implement IN behavior like that: 1
debug
  • 91
  • 1
  • 1
  • 5
7
votes
6 answers

Query large external list with CAML

I have a SharePoint external list that points to a 100,000 record SQL table. I have to set a filter on the Read List Operation otherwise the list doesnt work. It will timeout as it tries to return the full list. So I have added a Limit filter of…
Mort
  • 837
  • 1
  • 14
  • 20
7
votes
2 answers

CAML query to a SharePoint list, order by a lookup field

I'm attempting to pull a list from SharePoint via CAML and I want the list returned ordered by a specific field. The field is a lookup field. The query comes back unordered when I set the OrderBy to be the lookup field, if I use a text field it's…
kevingreen
  • 1,541
  • 2
  • 18
  • 40
7
votes
4 answers

Getting list item field values from a SP List using Client Object Model

What is the optimal way to get a list items and their properties from a SP list using Client object model? Here is the code I'm using. string server = "http://localhost"; ClientContext context = new ClientContext(server); Web…
Sandeep Singh Rawat
  • 1,637
  • 1
  • 14
  • 27
7
votes
1 answer

How to get the latest item created by a specific user by CAML query

I am trying to get the most recent item created by a specific user by CAML query but it seems to return all the data created by everyone. Help please. Here's my code: string lifestyleQuery = @"
janejanejane
  • 496
  • 2
  • 12
  • 30
7
votes
3 answers

How do I filter by [Today] and time in SharePoint list view ?

I'm trying to filter Sharepoint lists based on date and time. But It only works with date, ignores the time in data and time field.
Tabares
  • 4,083
  • 5
  • 40
  • 47
6
votes
3 answers

How to get all folders in a SPList, then checking permission "Contribute" for current user

I have a sharepoint list like that: List ---------Folder 1 -----------------Item 1 -----------------Item 2 ---------Folder 2 -----------------Item 1 -----------------Item 2 ---------Folder 3 -----------------Item 1 -----------------Item 2 How can…
Dương Diễm Quỳnh
  • 61
  • 1
  • 2
6
votes
1 answer

CAML > get an item by it's URL

Should this CAML be working. (I tried it with u2u and it does not display the URL column.) I get this error. {System.ApplicationException} = {"One or more field types are not installed properly. Go to the list settings page to delete these…
Mina Kumari
  • 85
  • 2
  • 2
  • 6
6
votes
2 answers

SharePoint's CAML query the "Created By" field with username

Hey, I have a form for administrators where they insert a user name ("domain\name") and the code gets and sets some information out of it. It's a huge project and some of the lists contain the username as a string ("domain\name"), but some lists…
yellowblood
  • 1,604
  • 2
  • 17
  • 32
6
votes
2 answers

How to work CAML Joins like SQL Joins?

I've checked articles on here and Googled till I'm blue in the finger tips. I've read and read and read and just can't seem to wrap my head around CAML Joins in Sharepoint2010. Question: Can someone please show me a full example of how exactly…
SpYk3HH
  • 22,272
  • 11
  • 70
  • 81
5
votes
2 answers

CAML Query Comparing DateTime with Eq

I'm trying to put together a CAML Query that compares two DateTime objects, but I cannot get it to work using an Eq comparison. From my testing I can get Gt, Lt, Geq, Leq to work with DateTime comparisons, but Eq doesn't seem to work at all,…
ferr
  • 1,137
  • 3
  • 12
  • 28
5
votes
1 answer

CAML Query to select top level folders only

I want to select the list of folders (without subfolders, not recursive) of a Document library using CrossListQueryCache. Everything is working fine except that i am receiving ALL the folders and subfolders in the list and not just the first level…
Zee99
  • 1,194
  • 2
  • 23
  • 46
5
votes
1 answer

SharePoint 2010 - error reading list items "Cannot complete this action. Please try again."

I have a SharePoint 2010 Farm solution that deploys a list, and a web part that reads from that list. It actually does more than that, but I can't get past the "read the list" part. I'm able to successfully query the list and get back the…
Mark
  • 346
  • 1
  • 2
  • 10
5
votes
1 answer

SPQuery : Difference between Query and ViewXml properties?

Hello SharePoint developpers ! I can't deeply understand the difference between Query and ViewXml properties in the SPQuery object. In the msdn documentation, it's written : Query : Gets or sets the inner XML used in the query. ViewXml : Gets or…
KitAndKat
  • 953
  • 3
  • 14
  • 29
1
2
3
…
42 43