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
17 views

CamlQuery Lookup not correct

I need to display the elements in Column "NetworkNodes" only SRV1 and SRV3 in Lookup, how to write correctly? The remaining elements of the SRV are not needed. Doesn't work like that: Query =...
0
votes
1answer
34 views

CAML in Powershell within 2 dates

I've been tweaking my code with various solutions discovered here and elsewhere with no luck so I figured its time to ask for help. I'm using Posh ver. 4.0 on SP 2013 Enterprise on-premises. I have a ...
0
votes
1answer
11 views

Unable to get the pages which have their calcualted date.time field equal today using CAML

I am working on an online SharePoint site collection, where I have a calculated column named "ExpiryDate" of type Datetime, and I want to get all the pages which have their expiry date equal today, i ...
0
votes
1answer
21 views

CAML query using a Choice field is not working

I have the following CAML query inside our SharePoint online site collection, to get all the list items which have a choice field named CustomerOrderAlert = No, as follow:- List ...
0
votes
2answers
31 views

CSOM Caml query get only root level folders in document library(paginated response)

Try to ignore some of the ugly if statements :D. I am very new to CSOM and caml. Is it possible to write Caml statement that returns the Folders in the Root of the document library only? Apologies ...
0
votes
2answers
42 views

Sharepoint Online Csom: Getting around 5000 view limit in document library in a paginated response

Let me preface this with, I begged them to let me re-organize the files a lot of different ways but they like looking at all files in one place. I am working on cleaning out a large Document Library ...
0
votes
1answer
38 views

Highlighted Content Custom Query Filtering

I am trying to write a simple query to filter highlighted content and can't figure out the CAML to accomplish it. The out of the box filter option is returning results in an odd order, and it needs ...
1
vote
1answer
11 views

CAML for Library within Library

I need help writing a CAML. Unfortunately, I have little experience with this and can't seem to formulate a query that works. I'm trying to show a library that is within another document library. I ...
1
vote
0answers
51 views

Using CAML to filter documents by Querystring on SharePoint Online modern pages

I need to create a SharePoint modern page which will display list of documents filtered using the value in the querystring (eg .../Documents.aspx?param=2). I have tried using "Highlighted content" ...
1
vote
1answer
21 views

Join two Lists with Where Condition in a Joined List

I am trying to create the Caml query for the following Scenario: I have two Lists: DocumentApprovalRequest DocumentApprovalComments Both the Lists has the column "DocumentNumber", I want to join ...
1
vote
1answer
28 views

retrieve files from sharepoint library failed after few files

Below is my code, it worked with too files and when ExecuteQuery load the third one, an error is timeout. no other error message got . ListItemCollection items = list.GetItems(CamlQuery....
1
vote
2answers
36 views

Deleting element from list using CAML Query not working (deleteObject of undefined)

I want to delete a list element using CAML Query. The element has the value 55 in the column CorrespondingListID. This is the function I use: deleteFromHistory: function(){ console.log("...
0
votes
0answers
20 views

CAML filter, RowLimit options not working with Spfx solution

This question may look duplicate but actually i didn't find any proper solution to this. Issue: Threshold error when I am getting items from list more than 5K even after applied filters with indexed ...
0
votes
3answers
55 views

How to count number of days from SharePoint list?

How to count number of days between two dates from SharePoint list using CAML query/JavaScript? Thanks
0
votes
1answer
27 views

CAML query return “Value does not fall within the expected range”

I have the following CAML query to iterate over a large SharePoint document library :- do { CamlQuery camlQuery6 = new CamlQuery(); // The RowLimit tells SharePoint to only scan ...
0
votes
1answer
57 views

Using “<Where><BeginsWith><FieldRef Name=\”FileDirRef\“ />” Rreturn Error:- The attempted operation is prohibited because it exceeds the list view [duplicate]

I have the following code inside my remote event reciever, the code will get all the folders and files under a specific folder:- CamlQuery camlQuery6 = new CamlQuery(); camlQuery6 = new CamlQuery()...
1
vote
1answer
28 views

Is there a way to select files that matches a certain regex with CAML?

$CAMLQuery = "<View Scope='RecursiveAll'> <Query> <Where><Eq><FieldRef Name='FileLeafRef' /><Value Type='Text'>bad_file</Value></Eq></...
0
votes
1answer
29 views

Can i get all the folders and files (under all level) inside a main folder using CAML

I have the following CAML query where i am trying to get all the files and folders that are directly and indirectly added to the folder named FolderA:- camlQuery6.ViewXml = "<View Scope=\"...
1
vote
0answers
60 views

Sharepoint Modern - Highlighted Contents

Ive been searching for awhile for this. Is anyone here successfully create a filter in Modern Sharepoint To show Pages that Logged-in User Liked? the modern sharepoint can query using KQL or CAML ...
0
votes
2answers
54 views

CAML query which contain a lookup field and single line of text is returning wrong results

I have a list named "Security Groups" inside my sharepoint online site, which contain a lookup field named Templates and a single line of text named "Folder", with the following sample data:- and i ...
2
votes
1answer
33 views

I want to get list where invoice _category is service please help? [closed]

I want to get the list items where invoice _category is equal to "Service". Please help? Current code: camelQuery.Viewxml = "<View><Query> <Where><Eq><FieldRef Name='...
0
votes
1answer
70 views

Getting and setting multiple items from a Sharepoint list using CAML query?

I have a SharePoint list Catalog. Using camlQuery I can get a list item value called Price. With the following code I get the Price value of the list element which has the ID 5 and store it in a ...
0
votes
1answer
15 views

Correct camlQuery to retrieve list item value via JavaScript and setting that value in another list

I have two lists: Catalog and Position. I want to retrieve the value of a list item in Catalogand use it for the value of a list item in Position. To get the list items' value Title, I used // Get ...
1
vote
0answers
73 views

pnp.js - Join 2 sharepoint lists using camlquery

I am facing issue with joining 2 sharepoint lists using pnp.js. I have 2 lists, the first one named "Phasen" have 2 columns, Title, Wow. The second list named "Projects", have 2 cloumns - Title, ...
0
votes
1answer
76 views

Query a single line of text filed using CAML <Contain> will return all items

I have a list inside SharePoint online site collection. the list contain a field named Processed which is of type single line of text, and only one item have a value inside this field while the other ...
1
vote
2answers
348 views

Does CAML query support Does Not Contain

I am working on a console application to integrate with SharePoint Online site collection. and I want a way to get all items that do not contain the word "fail" and do not contain the word "success", ...
0
votes
0answers
25 views

SPList returns no result if CAML query is modified or removed

I have a SharePoint PowerShell script which gets items from a list. I am changing the CAML query for different output. However, upon changing or removing the CAML query, the method of list.GetItems()...
1
vote
1answer
55 views

How to speed up file reading using SharePoint CSOM?

I have created a function using the SharePoint CSOM to extract all files within a Document Collection (List) using the below code however it takes over 5 minutes to get a list of 3671 files. Is it ...
0
votes
1answer
53 views

If Else in the CAML Append Method

I have been trying to do an if else condition in the append method however for some reason it's not reading the condition. Here is the code. Towards the bottom I want to show signNow if the list ...
0
votes
1answer
63 views

CAML - Getting the URL's ID for the Where Clause

Is there a way to get the ID from the SPGetCurrentSite? I want to use in my Where clause for my CAML Statement/ID field in the SharePoint list item. I'm new to CAML and I was using the below but I'm ...
0
votes
2answers
20 views

how to get this CAML query to work

I have a javascript and i can't get the CAML or listitems. //http://vadimtabakman.com/nintex-forms-multilingual-form.aspx NWF$(document).ready(function () { var language = NWF$('#' + ...
1
vote
1answer
21 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' />&...
1
vote
3answers
69 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
80 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
0answers
20 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
1answer
29 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); ...
0
votes
2answers
444 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....
1
vote
1answer
43 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
152 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 ...
0
votes
1answer
71 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
32 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
861 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
51 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 = ...
1
vote
1answer
57 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
53 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
89 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
102 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 ...
2
votes
1answer
33 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 ...
5
votes
2answers
293 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 ...
0
votes
1answer
137 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(...

1
2 3 4 5
11