Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
958 questions
0
votes
1
answer
30
views
CamlQuery to send email 3 days later
I am writing a a caml query i have a variable isDevelopmentReview whose status equals to be SaveAsDraft, type is choice and SaveOptions eq to Submit and type is choice and i have added a new field as ...
0
votes
1
answer
44
views
SharePoint CSOM API CAML Query to get all sub folder names of root folder paginated
I am trying to do something fairly simple with the SharePoint CSOM API. I have a library which has over 5000 folders in on the root level, i need to read the names of all of those subfolders as ...
1
vote
1
answer
215
views
Add-PnPView group by secondary field
I have created a script to create number of views in SharePoint, but I am unable to work out the CAML to group by more than one field if it's possible.
1 field being:
<GroupBy Collapse="TRUE&...
- 13
0
votes
1
answer
48
views
CAML Query to get items under folder\s ordered Ascending
I am trying to retrieve all the documents within a specified folder (including subfolders) and order them Ascending. I am getting all the documents but they are not ordered.
This is what I have so far:...
0
votes
1
answer
299
views
SharePoint CAML Query to get all folders that have a value for a specific field and were modified within the last five days
I am attempting to get ALL folders that contain a value for the ProjectNumber field and were modified within the last five days. This query only works when I remove the modified condition. Otherwise ...
- 103
0
votes
1
answer
623
views
CAML Sharepoint list to return email of Person Field
Goal: I have a Person column on a SharePoint list called Manager and I'd like to return the Manager Email for each list item as well as the value of a managed metadata field. I'm using the PnP JS ...
- 25
0
votes
1
answer
2k
views
Get all Files and Folders and subfolders from a Root Site in a tree view with C# in a PNP Core Framework
I'm currently using PNP Core Framework with a "normal" console application.
I want to get all Files and Folders from a specific Document Library. How can I do this in a simple way? I tried ...
- 31
0
votes
1
answer
742
views
CAML Query when using Or fails giving "Cannot complete this action"
I am creating an SPFX web part which queries a list in SharePoint Online
This works fine:
camlQuery = "<Query><OrderBy><FieldRef Name='LinkTitle' Ascending='TRUE' /></OrderBy&...
- 109
0
votes
1
answer
74
views
Can we define NOT IN inside CAML Query
I have this Power Shell script which work on SharePoint 2013 on-premises:
$NewHireList = $spSourceWeb.Lists["ONB New Hire"]
$NewHireItem = $NewHireList.Items | Where {$_["Candidate ID&...
- 1,420
0
votes
1
answer
34
views
CSOM search fails on Integer fields
I have a very simple query:
var where = "<Where>";
var decoded = decodeURIComponent(searchKey);
where += "<Contains><FieldRef Name='Nr' /><Value Type='Integer'>&...
- 1,199
0
votes
1
answer
627
views
CAML query to get all items which are modified or created today?
Can anyone help me with CAML query where items are created or modified today.
Trying below where I am excluding one specific item and getting modified item today but its not working:
<View><...
- 59
0
votes
1
answer
96
views
What is the REST URI that does the same as the CAML Query shown here
What is the REST URI that does the same as the CAML Query shown here
This CAML Query (works great):
CamlBuilder().View().RowLimit(5000).Query().Where().TextField('ItemDescription').Contains('laptop')....
- 3
0
votes
1
answer
179
views
How to format the output from CAML Query in SP Services
`
`function getFunding(){
` var Funding = [{}];
` var i = 0;
` //Web Service
`$().SPServices ({
` webURL: FundingWebURL,
` operation: 'GetListItems',
` ...
- 21
0
votes
1
answer
2k
views
How to exceed the Sharepoint 5000 threshold in Rest-API Python
I can't use Office365-REST-Python-Client to retrieve Sharepoint files because it's only works on Windows not on Linux - Docker (it throws error:
File "/usr/local/lib/python3.8/site-packages/...
0
votes
1
answer
95
views
CAML multiple AND Conditions
The CAML query below didn't work for me. Any help?
$viewQuery = "<Where><And><Eq><FieldRef Name='PP'/><Value Type='Integer'><UserID Type='Integer'/></Value&...
- 25
0
votes
1
answer
42
views
T-SQL to CAML - I wonder what's missing in the CAML (T-SQL works)
I have this SQL query and it works perfectly. However, when I try to create a similar CAML it doesn't work. Is there a tool that can convert SQL to CAML. or can someone please help. Here is the ...
- 3
0
votes
1
answer
101
views
Retrieve Lookup metadata using Caml Query?
This "Initiator" is a person or Group column in SharePoint online. I need all metadata(email, key) of this column.
- 11
0
votes
0
answers
193
views
Executing a CAML query will return this error: "Specified argument was out of the range of valid values. Parameter name: index"
I have the following code inside our console application, to loop through a list of number and query the SharePoint list which is inside a modern communication site:
foreach (var r in allrequests....
- 1,420
1
vote
1
answer
848
views
CAML - List Item Pagination in SharePoint 2016
I've got a .NET application that needs to retrieve items from a list and return them, I'm looking for a way to paginate the results in case the number of items gets too large.
I've checked out ...
- 151
1
vote
1
answer
2k
views
403 when making axios POST request
I have a feature that loads a map onto a page, and 5% of the time I'm hit with a 403 error and the map data doesn't load properly. I've had a very difficult time with triggering the error, but I was ...
- 111
0
votes
2
answers
345
views
Caml Query Date condition not working
In the below query after adding date condition the query returns error - Cannot complete this action. Please try again..
"<View><Query><Where><And><Eq><...
- 39
1
vote
1
answer
94
views
How can I join data from two custom lists in SharePoint add-ins?
I want join 2 custom lists in add-ins:
Data of Lists: QuanLyMembers.PhongBanId is ID value of QuanLyPhongBan
QuanLyPhongBan list:
QuanLyMembers list:
This is my code:
function getListMem() {
//...
- 123
0
votes
1
answer
266
views
Caml Query | How to copy today's list items from one SharePoint online list to another in batches?
I am trying to write a Caml Query to get only today's list items and then later copy it into the new list.
I am using the batch method to copy data from source list to destination.
source list gets ...
- 19
0
votes
1
answer
347
views
For loop Caml Query | How to use Caml Query for loop to increment the date range by month and also year once the loop reaches January?
I am using Powershell scripting to get data from a sharepoint list which exceeds the threshold of 5000 items.
I want to create a for loop which increments by month and year.
The Code in the for loop ...
- 19
0
votes
1
answer
32
views
How can i store camlquery results to filter and delete that i don't need?
I just want to change the result of camlquery. But i dont know how to store them and filter it. The query is now turning many values that i dont need. I want to drop them and show them in a view. So, ...
- 651