SharePoint Stack Exchange
SharePoint Stack Exchange

Questions tagged [caml-query]

An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

CAML (Collaborative Application Markup Language) is an XML based markup language used with the family of Microsoft SharePoint technologies. CAML contains specific tags for querying data.

CAML can be used to do the following:

  • Provide schema definition to the Web site provisioning system about how the site looks and acts.
  • Define views and forms for data and page rendering or execution.
  • Act as a rendering language that performs functions in the DLL like pulling a value from a particular field.
  • Provide batch functionality for posting multiple commands to the server using protocol.
956 questions
10
votes
2 answers

caml query to get listitem by Name field

I am trying to check if a filename exists in the 'Name' column of Shared Docs Library. I think only CAML could help here. So I made this query "" + docname + "" But I get…
sanju
  • 101
  • 1
  • 1
  • 3
8
votes
1 answer

CAML: Filter URL field on description (not on URL)

I have a list with an URL-field. Nothing special, just the OOTB Hyperlink-field. I want to execute a CAML-query that selects items with a certain value in the description part of the URL-field. CAML
Dribbel
  • 2,906
  • 3
  • 31
  • 45
8
votes
1 answer

CAML query builder that supports inner joins?

I'm Looking for a query builder that can assist me in creating CAML queries that will contain inner joins. Does anything like this exist? Update: To ask my question more clearly, I am looking for a software package that assists in writing these…
JL01
  • 1,219
  • 5
  • 22
  • 36
6
votes
4 answers

Using Date offset in CAML query

In SharePoint 2010, Inned to get items from a list based on a condition. Considering one of the fields to be 'EventDate' of type DateTime, the condition is: (EventDate - 60 Days) <= Today <= (EventDate + 30Days). Note that the values 60 and 30 are…
suhas
  • 394
  • 1
  • 5
  • 15
6
votes
4 answers

Where can I find a list of CAMLvariables and ServerVariables?

Having some trouble finding a list of these variables. Any help would be greatly appreciated. More specifically, when I see this on the page: I want to know…
Mike T
  • 416
  • 6
  • 20
5
votes
4 answers

CAML query error when creating SPQuery query

I have this CAML query var query = new SPQuery{ Query = string.Format(@" …
user2536
4
votes
2 answers

CAML error: "One or more field types are not installed properly."

I'm using the U2U CAML Query Builder tool and no matter what I do, I can't create a query. It keeps generating the error: One or more field types are not installed properly. Go to the list settings page to delete these fields.0x81020014 If I just…
Alex C
  • 4,395
  • 22
  • 84
  • 116
4
votes
2 answers

Filter Fields using Caml Query

Normally I have this query, filtered with MostrarHome eq 'No' var queryGallery = "$select=Title,Description,Enlace,EncodedAbsUrl,Categoria/Title&$expand=Categoria/Title&$orderby=Title asc&$filter=MostrarHome eq 'No'"; So I try to do it in Calm…
Jesus
  • 41
  • 3
3
votes
1 answer

CAML query speeds

So I have a list of about 75,000 items. I want to know if I perform a CAML Query that returns a couple of hundred items, is that going to be slow? (slow = 10+ secs, med = 5-9 secs, fast 0-4 secs) Thanks
will
  • 329
  • 4
  • 13
3
votes
4 answers

Not IN CAML Query

I have two Lists in SharePoint 2007 Clients Actions Actions list has a Lookup column called Client which takes its values from Clients List. I want to display all those clients which are NOT present in Actions list. My approach is to first get all…
Namwar Rizvi
  • 684
  • 1
  • 4
  • 19
2
votes
1 answer

caml query to filter by year not working

I would like to filter a list based on the year as parameter. For e.x. if i use 2014, all items from 1/1/2014 to 31/12/2014 should appear and also i am filtering on region. For the caml query below, if there is an item which was entered on 1/1/2014,…
Stan
  • 21
  • 1
  • 2
2
votes
2 answers

CAML Returning Tomorrow's Value when filtering Today

I have the following CAML query for SP2003 SPQuery qry = new SPQuery(); qry.ExpandRecurrence = true; qry.CalendarDate = DateTime.Now.Date; qry.Query = ""…
David Lozzi
  • 7,372
  • 5
  • 29
  • 50
2
votes
1 answer

How can I use managed metadata field in the where clause of CAML?

How can I use managed metadata field in the where clause of CAML?
Sachin
2
votes
3 answers

Unable to return items under folder using CAML

I have a folder in the default "Images" library under my site, called Menu Icons: /PublishingImages/Menu Icons I want to retrieve only the images under this folder, and not all images under the root as well, so I thought something like this would…
JadedEric
  • 523
  • 7
  • 21
2
votes
1 answer

CAML Query throwing error

Pretty new to CAML queries, but trying to query a list based on Status = Completed and a date range. It is throwing the following error "Unexpected Error: One or more field types are not installed properly. Go to the list settings page to delete…
Carl Frank
  • 21
  • 1
1
2 3 4 5