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]

Collaborative Application Markup Language (CAML) is an XML-based language that is used in Microsoft SharePoint Foundation to define the fields and views that are used in sites and lists.

2
votes
0answers
18 views

Sharepoint CAML Query does not work in IE when searching by Taxonomy Field

I've the code below: function ReceivePages(FirstFolderProd, FirstFolderWithoutSpaceProd, GetTagFolder){ var restUrl = "https://tenant.sharepoint.com/sites/sites/Negocio/...
0
votes
1answer
31 views

CSOM CAML query with ID row limit 1 returning list threshold error

I'm using the following CAML query in my CSOM code to try to determine the highest list ID in a list. I'm getting the standard list threshold limit error (because the list contains over 23000 items). ...
0
votes
1answer
40 views

SharePoint CAML Query - Chinese Site

Trying to select from Library(Chinese Characters) getting -Object reference not set to an instance of an object - This working for English sites - Not sure how to convert? ClientContext context = ...
0
votes
1answer
1k views

SharePoint REST API CAML Query error : “Every two elements in an array and properties of an object must be separated by commas."

While quering with the CAML query in the SharePoint REST API throws following error. { "error": { "code": "-1, Microsoft.Data.OData.ODataException", "message": { "...
0
votes
1answer
1k views

Recursive CAML query

I would like to search items between two dates in a DocumentLibrary. The query find the files at root just right. However the query doesn't seem to be considering files in folders. Here is my attempt ...
5
votes
4answers
12k views

Multiple Values in CAML query from Array? SharePoint 2010 using jQuery/SPServices

So if I use SPServices to GetListItems with CAMLQuery, is it possible to insert multiple values inside Value Type='Number'> here I would like to evaluate things throught a flow in my page, add to an ...
0
votes
2answers
966 views

SP.CamlQuery().set_viewXml() returns undefined

I am trying to run a CAML query to sort through some data. Once the page finishes loading i do not get the results i want. I checked the functions and it turns out that for some reason, my CAML query ...
0
votes
0answers
8 views

Filter webpart for XsltListViewWebPart postback and paging problem

I am building a custom list filter webpart farm solution for Sharepoint 2013 and 2016. It is put on the same page as the XsltListViewWebPart to be filtered. I do this by changing the caml query inside ...
1
vote
1answer
17 views

CAML QUERY does not work in IE11 when searching by content type

I've this code below: function BuscarDocumentosHoje(Departamento,NivelAutorizacao,NumeroColaborador,todayfinal){ var restUrl = "https://tenant.sharepoint.com/sites/site/Negocio/Precario/_api/web/...
0
votes
1answer
14 views

CAML - Querying with multiple WHERE Clause

Getting my feet wet on CAML. I was able to get a query that shows a count for a list. Now I need to do count based on multiple information. Dog Dog Cat Cat Cat fish fish fish fish Loops through and ...
1
vote
1answer
47 views

Get unique value using Sharepoint CAML Query JavaScript

I've this code below: function ReceivePages(FirstFolderProd, FirstFolderWithoutSpaceProd, GetTagFolder){ var restUrl = "https://tenant.sharepoint.com/sites/site/Negocio/OfertaParticulares/...
1
vote
1answer
6k views

The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested

I am getting below error on the second request. Strange thing is its not occurring on first request. The collection has not been initialized. It has not been requested or the request has not been ...
0
votes
1answer
36 views

Not understanding why one CAML query is throttled, but not another

I am not understanding why this CAML query from CSOM is getting throttled: <Query> <Where> <And> <Eq> <FieldRef Name="Period" /> <Value ...
1
vote
1answer
2k views

Add filter and pagination to CAML query

I'm developing a visual web part for Sharepoint 2010. I would display all documents from a specific DL, but this DL contains more than 7000 items. So I would like to add a pagination (show only 20 ...
6
votes
1answer
2k views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
5
votes
2answers
105 views

Create list alert with filter on managed metadata field

I'm trying to create an alert on a list. The alert should only trigger on a subset of the list items for which a certain managed metadata field has a certain value. So I'm setting the Filter-Property ...
2
votes
1answer
5k views

Client Object Model & CAML -> Getting Items of a specific view

I need some support as I am struggling to understand what is wrong with my code. I try to retrieve the data of a specific view. The line camlQuery.ViewXml = view.ViewQuery; throws an exception The ...
2
votes
1answer
31 views

unable to create a list view to filter my Wiki Pages which contain the following text 'T:\' inside their “Page Content” field

I am working on an enterprise wiki site collection inside our sharepoint on-premises 2013. and i want to create a list view which shows all the wiki pages which contain the following "T:\" inside ...
2
votes
3answers
5k views

Web service based CAML query breaks 5,000 item limit

I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents: <...
0
votes
3answers
630 views

CAML Lookup - get different value from lookup list using query

Say I have two lists: Support Pack ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True Support Pack Template: ID : 1, OtherValue: x, SuppType: 10 hr support pack ID : 2, OtherValue: ...
1
vote
1answer
664 views

How to JOIN two lists by lookup column in Sharepoint Online

I'm a newbie in javascript and i'm using jsom to retrieve list items in Sharepoint Online. I have two lists BnzPersons and Sessions. This is my first code variant: <div id="divListItems"></...
1
vote
1answer
678 views

Sharepoint Online REST api CAML query not returning file related columns

I'm trying to query a document list from a SharePoint Online server using REST API. I have to use CAML, otherwise filtering is not possible on the taxonomy field as far as I know. Below is the ...
0
votes
1answer
859 views

Sharepoint Online CAML query very large list checked out files, csom powershell or c#

I have poured over a ton of posts and code and none seem to work with checked out files and really large lists. I am newish to sharepoint, especially online. I moved a doc repo up there for testing ...
0
votes
1answer
714 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
0
votes
1answer
32 views

How to print the result of caml query?

I've got a list with 2 columns col1 and col2. I wrote a CAML query and I want to print the value from the second column corresponding to the value from the first using (SPSite site = new SPSite(...
0
votes
1answer
27 views

javascript plugin working only ctrl+F5

im test new template and using camljs lib. next step to read javascript not work a loop, becouse read htmlcollection aint return length. i can view returns only refreshing with ctrl+F5 or ctrl+shift+...
0
votes
3answers
118 views

caml query won't return rows with null value in contains query

I have written a CAML query using <Or> with <Contains>. the query looks similar to below: <Where> <Or> <Or> <Contains><FieldRef Name="Field1" /...
0
votes
1answer
52 views

how to change caml query with condition <OR> for 5000+ list items

I have this CAML query that wouldn't work if i change it to but works with HOWEVER. since our list no has 15k items using OR doesnt work. basically this remote event receiver gets list items with ...
1
vote
1answer
22 views

Retrieve a Value From A List Based On Who Is Logged In

I currently have the vacation days for all the employees saved in a SharePoint list. I would like to display the number of vacation days the employee that is logged in has on the Home page. For ...
0
votes
1answer
75 views

CAML filtered list views - filter more than one nested level?

do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups? I've ...
1
vote
2answers
2k views

Retrieve List items using CAML Query

I have a list which contains 3 columns -ID, TicketState and EndDate ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed 01/12/...
3
votes
2answers
3k views

Caml Query - skip X first results

Let's assume I have list with 100 items. Is it possible to write CAML query to get 5 items, but skip 10 items from the beggining? Something like LIMIT and OFFSET in SQL?
1
vote
1answer
39 views

CAML Query with more than one condition

Hi I am currently writing a sharepoint add in application which reads and writes to sharepoint lists. For one of the lists I want to retrieve a list item based on the user logged in and also based on ...
1
vote
1answer
67 views

CAML query returns different data

I created a CAML query that I need to use as a workaround for REST API and the 5k threshold limit: However when I was testing it using the SharePoint CAML Query Helper Online, it returns the correct ...
0
votes
2answers
42 views

SharePoint List Query fails with error “Request failed, cannot complete this action”

I'm trying to query a SharePoint list on my root site collection but keep getting the error "Request failed, cannot complete this action". I messed around with the CAML query below and have figured ...
0
votes
2answers
22 views

Is there a sotfware to create, manager and CAML query SharePoint Lists without having SharePoint installed on a computer?

I'm working on a SharePoint site at work, however due to PCI compliance I am not able to access SharePoint at my house, I was trying to find a software on which I can be able to create lists and use ...
0
votes
1answer
48 views

How To: Filter A Query on All Lists Based on Title Contains

I have queried all of the lists within a subsite but need to filter based on criteria in the title. I then need to display the filtered list contents. Is this possible if the list contents are not ...
0
votes
4answers
61 views

How To: Query & Display items from ALL lists within a subsite

I am looking to query and display items from all of the lists that exist (and will exist in the future) on a specific subsite (SP 2013). Below is what I have so far but it is not producing any alert,...
1
vote
1answer
36 views

SharePoint 2010 GetListItems - Problem with CAML Query

This works "<Where>" + "<And>" + "<Geq>" + "<FieldRef Name=\"StartDate\"/>" + "<Value Type=\"Date\">" + DateTime.Now....
1
vote
2answers
12k views

CAML Query in Powershell Issues

I have a powershell script that I am running that executes a caml query to get some list items. The problem I am having is that whenever I execute this query in CAML Builder I am only getting 3 ...
0
votes
2answers
345 views

How to load all list items using caml query?

I'm using SP 2013. And I have a Wiki Page Library. I try to load all items from this list. I'm using the following code: var context = new ClientContext("SiteUrl"); context.Load(context.Site); ...
0
votes
1answer
358 views

Can i reach the lookup column's data with CAML query?

I want to reach list's datas. There is look up column. I am using CAML query. But when i create query with CAML, i am seeing look up column like Microsoft.SharePoint.Client.FieldLookupValue[].I want ...
6
votes
3answers
5k views

Query multiple lists using javascript/CSOM

I'm about to query multiple lists using JavaScript (JSOM, SharePoint 2010). It's working when querying one list in a time, but that's annoying when I'm having lots of lists. Working example: ...
1
vote
1answer
55 views

JQuery / CAML Undefined Error

I found some code on line, see below, and changed it to meet my needs but when I run it I get: Due Date undefined This is the only value in the list, but it should look like: Due Date 01/31/2019 ...
0
votes
1answer
146 views

CAML Query : Where clause not working with View tag & RowLimit

I've reached the maximum view threshold limit on a SharePoint List, with a little more than 5000 item in it. When I raise the limit in the webapp's settings, everything is working fine, but I would ...
0
votes
1answer
640 views

Is it possible to get all list items using CAML-query?

I'm trying to retrieve items from all lists on current site collection. Is it possible to do that using a CAML-query?
0
votes
3answers
40 views

caml query that searches for specific records

hello everyone form this query to find column records until this moment works for me but when I want to add that look for other records of the column department gives error I would appreciate your ...
0
votes
3answers
33 views

When running a CAML-Query without OrderBy: Are IDs always incremental?

I want to bulk load a few items from a list. The Caml is something like this: <View><Query><Where> <Gt><FieldRef Name=\'ID\'/><Value Type=\'Number\'>{id}</...
6
votes
1answer
155 views

SharePoint 2010 list Item Query

We have a big list in SharePoint 2010. I'm gonna query SharePoint 2010 list item in the web part based on country. I used CAML and JS. I have got errors in different browser" Internet explorer says ...
1
vote
1answer
47 views

Get the list specific rows from sharepoint where value exist

I am working in c# and I have a list of strings which contains the projectid of the SharePoint list List<string> guidlist = new List<string>(); // contains project ids On the basis of ...