Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit 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.

16
votes
5answers
69k views

Get Items Under Folder CAML

I am trying to retrive all items that are under a certin folder, in a document library. this is what i have so far List DocumentsList = clientContext.Web.Lists.GetByTitle(list); CamlQuery camlQuery ...
16
votes
5answers
51k views

How to get current user with javascript?

I have a list . I want select items of list with a special quary.(get items that created with current user). Then get count of items. I use this code for get current user : function Initialize() { ...
5
votes
1answer
15k views

Sharepoint REST API - Using caml query and select/expand to get lookup data

I have a Sharepoint app and I use a caml query to filter the data I get back: var caml = "<View><Query><Where><And><Contains><FieldRef Name='PublishingPageLayout' ...
8
votes
6answers
15k views

How to query using CAML when a value has < in the value

I'm using SPServices to query a list, using CAML, and the column I'm searching (Title) have values that contains < and >. Is there anyway I can use CAML to find these values? It seems that I'm ...
6
votes
1answer
9k views

Make CAML query with in rest api call

I have a SharePoint list and i need to get the list items by using JSOM.how to add CAML query with in the API method? i have used the below code var url = "/_api/Web/Lists/GetByTitle('list')/...
7
votes
1answer
6k views

CAML query recurrent events problem

Here is the code I use: SPQuery query = new SPQuery(); query.ExpandRecurrence = true; query.CalendarDate = new DateTime(2013, 1, 1); query.Query = @" <Where> <DateRangesOverlap> ...
7
votes
2answers
29k views

How to use GroupBy in CAML query

I have simple list, consisting of 2 columns - Date, Order. Now what I want to do, is to GroupBy Date and count orders. So, for example if I have following items Date Order 08/10/2012 5 08/...
9
votes
2answers
27k views

CAML Query with Date Range

I'm writing an SPSiteDataQuery and I am having issues with the Query property. I need to return all results where the Record_x0020_Yr_x0020_End_x0020_Date is between 12/31 of the current year and 90 ...
5
votes
4answers
20k views

CAML query not working

I have written following CAML query to Retrieve items which are due in 7 days, It doesn't seems to be working, Please let me know what I missed ? string internalEndDate = web.Lists["List Name"]....
23
votes
3answers
33k views

CAML query limitation of values in IN operator

I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query. <Where> <In> <FieldRef Name="ID" /> <Values> <...
22
votes
4answers
31k views

Where can i download the U2U CAML query Builder for Sharepoint 2010?

I have try to download form below links. But the site is not opening. http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip . http://www.u2u.be/res/tools/camlquerybuilder.aspx http://www....
15
votes
1answer
20k views

Syntax for including fields dynamically in CSOM query?

What is the proper syntax for including fields dynamically in a CSOM listitems query? For example, this would apparently work: foreach (string field in fields) { clientContext.Load(items, includes ...
4
votes
2answers
3k views

CAML: Possible to query non existing field?

I'm using SPSiteDataQuery to fetch list contents from 2 different lists. List A) has the fields CustomField and Title List B) has only Title Is it possible to build a (filter) query with ...
4
votes
2answers
10k views

CAML query returns all items instead of one

I am querying a list to return only items matching a certain title, but the query returns all items. It seems I built or execute the query the wrong way: /* SP is an alias for Microsoft.SharePoint....
2
votes
4answers
16k views

How can I Create a join between two sharepoint custom list using CAML Query?

Will you please provide me help to create a join between two SharePoint lists using CAML Queries. I am using SharePoint 2010 Development Platform. Thanks in advanced.
1
vote
2answers
14k views

Retrieve single field using CAML Query in Sharepoint using Javascript

I have a List called ProjectInformation and contains following Fields.. ID ProjectName1 ProjectManager ProjectExecution 1 EDS PPB Time and Material 2 CS ...
9
votes
2answers
27k views

How to write CAML Query with more than 3 AND Condition

I have search and see the way how to write CAML Query with 3 AND conditions. However, I am not sure how to write CAML Query with more than 3 AND conditions may be with 4 or 5 AND conditions. Can any ...
8
votes
1answer
2k views

How to Combine IN-Opeator with LookupIds in a caml-query?

I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine: <Where> &...
6
votes
2answers
27k views

CAML query on Sharepoint List without duplicates

How can I retrieve all elements in a List ignoring duplicate entries So if List A contains: Employee A Employee A Employee B Employee B Employee C Employee D Employee E I want to get ...
5
votes
4answers
22k views

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 <= (...
3
votes
4answers
10k views

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 ...
3
votes
3answers
3k views

Caml query to get the next event from calendar

I'm facing a problem building a caml query for the calendar list. Here is my caml query SPQuery query = new SPQuery(); StringBuilder sb = new StringBuilder(); ...
2
votes
1answer
4k views

CAML Query of List's Lookup Field

I have a child form and I want to get the total of the child forms to update the parent with the sum total. I am struggling with the CAML query to get the total back. The below returns zero records at ...
2
votes
1answer
2k views

CAML query join and sort by column of projected fields

I am trying to execute the following query: query.Query =<Where> <IsNotNull> <FieldRef Name='Product' /> </IsNotNull> </Where> <OrderBy> <FieldRef Name='...
1
vote
2answers
4k views

Using the Now() function in CAML Query?

i am trying to get the 3 most upcoming events from the current date and time (The current data and time refers the time everytime my web part loads. Basically it is not a fixed date and picks up the ...
1
vote
2answers
447 views

CAML query daterange not working

I am trying to retrieve list items using date range based on date column. It implicit both 'Fromdate' and 'Todate'.My CAML query is also querying on two other conditions as well. I am using the below ...
0
votes
2answers
2k views

caml query for filtered lookup column

My project uses the 2010 version of the Sharepoint Filtered Lookup Field, which has the option to filter a column using a caml query. So I have three lists: Categories, SubCategories and MainList. ...
3
votes
1answer
8k views

CAML and External List - pass parameter to ReadList (finder) method

I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
17
votes
4answers
15k views

CAML Now Instead of Today - CAML Bug?

I have a CAML query, in which the <Where> node looks like: <Where> <Leq> <FieldRef Name='PublishedDate'/> <Value Type='DateTime'> <Today/> </...
10
votes
4answers
6k views

SharePoint 2010 CAML Query fails when indexed columns used

I have an SPQuery that has been working fine until my list hit 500 items: q.Query = "<Where><Eq><FieldRef Name='DefectID' /><Value Type='Counter'>" + DefectID + "</Value>...
9
votes
6answers
18k views

Caml query builder Office 365 Sharepoint Online

Does anyone knows where to find a CAML query builder that I can use for Office 365, Sharepoint Online? (if there exists one)
6
votes
4answers
6k views

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: <ParameterBinding Name="UserID" Location="CAMLVariable"...
3
votes
3answers
7k views

How to get a old version of list item?

I need to get all field values of an specific version. It is possible by sharepoint hosted app (javascript)? I need to create a custom version history page of itens. If there is a caml query ...
5
votes
2answers
1k views

Problem with CAML SPQuery ItemChildCount result

I know that this query works fine SPQuery query = new SPQuery(); query.Query = "<OrderBy><FieldRef Name='ItemChildCount' Ascending='FALSE' /></OrderBy>"; But my ...
3
votes
1answer
4k views

How to get all checked out files in SharePoint client object model c#?

I need to get all checked out files from a document library. I am trying by following query. CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = @ "<View> <Query> ...
3
votes
1answer
4k views

How to get only the first x items starting at position y from a list, using CAML query?

In sharepoint 2010 client object model in javascript, I want to create a caml query, that can download items from a list. I have this part working, but I want to download only x items, not the whole ...
2
votes
2answers
8k views

Getting items from rows 4-8 in a Sharepoint list using CAML query?

Here is the code Im using to retrieve the first 4 most upcoming announcements from the OOTB announcements list in sharepoint: How do I modify this to retrieve the next 4 (5,6,7 and 8) most upcoming ...
13
votes
4answers
76k views

Building CAML query with AND and Order by Clause

Hi I am trying to build a query using caml query builder - Below is the query (The query = get the values only whose address = 1234st AND LastName = Doe) - I believe the placement of AND operator is ...
8
votes
1answer
7k views

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 ...
7
votes
2answers
35k views

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 "<Where><Eq><FieldRef Name='Name' />&...
6
votes
3answers
3k views

Change sort order in returned ItemsCollection

I am fetching a collection of items from a list using a CAML query. The returned items are then populated in my custom HMTL table. There is, however, another HTML table for which I need the same ...
6
votes
1answer
2k views

Need help with CAML in CQWP

I tried to implement a CQWP web part that could show me all the checked-out files following this guide: http://www.the-north.com/sharepoint/post/Further-Customise-CQWP-to-Display-Draft-and-Checked-Out-...
6
votes
2answers
182 views

Selecting only PowerPoint files in a CAML query

I am trying to select all PowerPoint files in a list. How do I do that? Up until now I used this: class UsedIn { private static NetworkCredential credential = new NetworkCredential("login", "pwd", "...
5
votes
4answers
7k views

How to apply CAML query on the Calculated Column of the list?

I have a calculated column that stores the calculated date value. When I apply the CAML query, it does not return any row even if the record exists.
5
votes
3answers
10k views

How to query list with >5000 items in SharePoint Online?

I want to query a list in SharePoint Online which has >5000 items. How can I do it? Right now it is showing me thresh hold limit error when I am trying to query the list.
4
votes
2answers
4k views

Retrieving list Items programmatically from CAML via Client Side object Model when a Document Library has more than 5000 items

I have a SharePoint provider hosted app that stores documents with metadata in a Single Document Libraray programmatically via CSOM. I have a requirement to display the list items in a MVC web app ...
2
votes
4answers
7k views

Where can I find a good CAML tutorial?

I am just starting to get my feet wet with SP Foundation 2010, and need to customize some web parts. I am looking for some CAML tutorials that go beyond what's on the MSDN site, and also include the ...
2
votes
4answers
16k views

get all document from all folder and subfolder from document library sharepoint 2010

I want to retrieve all documents from folder to it's subfolder and so on using client object model.Please help me.
1
vote
2answers
638 views

How to write a caml query that filters by .pdf or folders?

How can I write a CAML query (for javascript ecma) that filters by only pdf documents or folders in sharepoint 2010? (this is for document libraries) Thanks.
1
vote
3answers
28k views

Use CAML query based on ID to retrieve a file name?

With jquery and spservices, I use getSelectedItems to retrieve the IDs of a few documents. Can I have a loop which goes through a caml query for each of those IDs to retrieve the file name (...