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.

Filter by
Sorted by
Tagged with
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 ...
1
vote
1answer
17 views

Combine 3 queries for different lists into one

I am building API for client side apps. There are 3 API requests for 3 different lists as following: tasksQuery = string.Format(@"<Where><And><Geq><FieldRef Name='Created' />&...
0
votes
2answers
1k 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 ...
1
vote
1answer
7k 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 ...
1
vote
3answers
49 views

CAML queries suddenly quit working; SP Online; SPServices

I have CAML queries performed against SharePoint Online lists through SPServices that have worked beautifully for 5 years. Sometime in the last couple of weeks they started returning incorrect results....
0
votes
1answer
39 views

Get single field value for all items from a list having very large number of items

I have a list with about 100K items. There could be gaps in the beginning and in between for SharePoint generated Ids of these items (due to deletions). List items data is live and keep changing. My ...
0
votes
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 ...
0
votes
0answers
13 views

CAML Query all lists with same name under a site collection

We are using SP2016 on-premise. We have a site collection with over 50 subsites under it. All the subsites are created with same Site template. Therefore all of them have a list called "ContactInfo".(...
0
votes
0answers
26 views

'n' number of CAML queries in a single executeQueryAsync function

How to execute 'n' number of CAML queries to get a different list of objects? We can use multiple clientContext.load() if we have a defined number of queries like clientContext.load(collListItem); ...
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 ...
0
votes
3answers
672 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: ...
0
votes
2answers
32 views

SharePoint CSOM list group by and filter

I have a list with columns "fruit" and "ripeness". Using csom, how can I return "Banana" where Yellow count >= 3? ClientContext ctx = new ClientContext("https://sharepoint.blah.com"); List list = ctx....
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: <...
1
vote
2answers
853 views

CSOM C# Caml Query on managed metadata field not working

I am trying to find an item in a list where the managed metadata field is equal to a certain text value. This is the code that I have which is not getting any items in the list (ListItemCollection ...
1
vote
1answer
30 views

CAML Query not Working Correctly

I want to return the events in an Event Calendar for the current week for a web page. I would prefer the current week Friday through Sunday, but that seemed too complicated. When I use this code it ...
0
votes
1answer
29 views

Get-PnPListItem : Cannot complete this action

I am trying to get an item in a SharePoint list using a CAML query so that I can update it. I am using data in a CSV file but when I run the script, it's failing on Get-PnPListItem. Based on some ...
1
vote
1answer
745 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
752 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
1k 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 ...
1
vote
1answer
151 views

How to add CAML query results with ListItems to a datasource of a repeater?

I am using SP2010. I have created a CAML query. This query has listItems as results. I would like to add these items to my repeaters datasource. How can I implement this?
0
votes
1answer
24 views

CAML Query to search comma separated values similar to SQL query

Instead of below query, is possible to write dynamic CAML query for below CAML query. because below query will not work for dynamic data: <Where> <Or> <Or> &...
2
votes
0answers
23 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
134 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
42 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": { "...
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
0answers
21 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
32 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
24 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
66 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/...
0
votes
1answer
66 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 ...
5
votes
2answers
163 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
32 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 ...
1
vote
1answer
725 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"></...
0
votes
1answer
73 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
30 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
157 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
71 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
23 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
123 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
41 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
94 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
57 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
26 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
60 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
72 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
48 views

SharePoint 2010 GetListItems - Problem with CAML Query

This works "<Where>" + "<And>" + "<Geq>" + "<FieldRef Name=\"StartDate\"/>" + "<Value Type=\"Date\">" + DateTime.Now....