Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
922
questions
0
votes
1answer
27 views
How to download all of the files under a specific folder using CSOM from SharePoint Online?
I have a folder structure similar to this on our SharePoint Online site:
Documents/
Drawings/
For Review/
Released/
Archived/
Documentation/
For Review/
...
0
votes
1answer
22 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 ...
0
votes
2answers
29 views
Format size different on some Multiline text when I print to PDF
I created my own custom print page (HTML) from a SharePoint List. The only issue is, some of the multi-line text is showing up in different font-sizes when printing to PDF or Print Preview in IE or ...
0
votes
1answer
25 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 ...
2
votes
1answer
26 views
Powershell Script Sharepoint Online | how to change a value in a list item (column)?
I have a list with a list item/column 'Category'. Let's say Category has values 'A','B', and 'C'.
I want to find all the values which are 'A' and replace it with 'B'.
How should I do it?
I tried the ...
0
votes
0answers
31 views
Caml issue with Highlighted content web part
My name is Obeybe and I'm new in Sharepoint online.
I'm facing an issue with the "Highlighted content" web part.
In a communication site I want to show the 5 latest pages added into "...
0
votes
1answer
22 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, ...
0
votes
0answers
9 views
I want to filter the the returned results of camlquery one more time and show it in listview?
So i have a value that called unitnames .
And i cannot search this value with <Eq> keyword, because one data column have semicolons.
But i cannot search it with <Contains> because it ...
0
votes
2answers
13 views
Add multiple Fields For the CamlQuery in Sharepoint Hosted App
I am trying to filter two fields or more that is clean of null values.
It works for the first field but it is not working for the second field:
<View><Query><Where><IsNotNull>&...
0
votes
1answer
23 views
How to query SharePoint items that contain one or more text values CAML?
I want to query for SharePoint items that contain at least one or more specified texts. For example, I have a field called "Pets." A SharePoint item would have a value that looks something ...
1
vote
1answer
33 views
CAML query to get all items which are 2 days from today
I have a site column of type Date and Time as follow:-
Now i want to query and get all items which have their Approve By exactly 2 days before Today. so let say today is 24 Sept 2020 then the query ...
1
vote
1answer
49 views
CAMLQuery is not rendering title item from the list
Here is the list (please note 'Full Name' column has been changed to 'FullName' since I took this shot:
Here is the CAMLQuery:
$(document).ready(function() {
var camlQuery = "<View>&...
0
votes
0answers
127 views
Highlighted Content CAML Query help
I am having problems with a Highlighted Content WebPart in SharePoint Online where I am using a custom CAML query to filter content from a Page Library on another site collection.
Senario:
I have ...
1
vote
0answers
34 views
CAML query display items in list that users are in group and assigned to
I am trying to have the items listed to users based on their assigned group and when specifically assigned to. I have a group field and an AssignTo field. Users can be in 1 or more group. Other users ...
0
votes
1answer
76 views
How to Retrieve data from SharePoint list via PnP JS Core and CAML Query
As I am new to SharePoint framework, I am using PnP JS core library in SharePoint webpart,please suggest how can I retrieve list items from SharePoint list via PnP JS core and CAML Query.
Please ...
0
votes
0answers
99 views
CAML Query for SharePoint Online - ViewFields not working
I am trying to use PnP with CAML Query to retrieve all items in a document library where certain fields meet certain values. The query filter is working fine, it retrieves the correct documents, ...
0
votes
1answer
113 views
how to read people picker column using caml query
I am trying below code but unable to read name from Custodian column value which is people picker, it always show me id
jquery.ajax({
url: `${reactHandler.props.siteurl}/`+...
1
vote
2answers
32 views
CAML query not able to filter data retrieved from SharePoint
I have been working on a SharePoint Online System which stores data related to various products in different document libraries and lists.
In this SharePoint Online System there is a requirement of ...
0
votes
1answer
38 views
Unable to add item with a lookup column value using CAML query
I have a PowerShell script that add's a new item to a list which has 2 lookup columns to different lists
first part of the script add's the item with the correct lookup value:
$ListLookupitem = $...
1
vote
2answers
43 views
CAML Query not display in Sharepoint2013
My end goal is to display items from SharePoint 2013 list that is more than 60 days from today and status is in process. This is my first time using CAML Query in JavaScript. I am not able to have the ...
0
votes
0answers
16 views
Unable to query SharePoint list by date using CAML and PowerShell
I am trying to use a CAML query through PnP powershell to get a list of items. My code looks like this:
$today = get-date -Format "yyyy-dd-MM"
$today = $today + "T00:00:...
0
votes
1answer
20 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
2answers
228 views
Filter a list by User or Group column in CAML Query
Is there a way to filter a list by User or Group column?
I need to get all the tasks assigned to each user in a site.
I got the below code for now, but that only works if I'm trying to get my tasks.
...
3
votes
0answers
157 views
Difference between camlQuery.AllowIncrementalResults=true and camlQuery.AllowIncrementalResults=false?
My aim is to get all items from a SharePoint List (>5000 items). I have used the standard pagination based approach and it is working fine.
ListItemCollectionPosition position=null;
do{
...
0
votes
1answer
22 views
Query for unique item in list
I have an SP list of items, each item has a unique Title. I would like to use the title as my way to find and then update that row of data. I thought the below code would find only the item that has 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
33 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 ...
1
vote
1answer
42 views
Sharepoint 2013 Set Javascript Caml Query output to variable for use in other functions
I am using Javascript to create a CAML Query to get data from a list in Sharepoint 2013. It works perfectly. Instead of pushing it to HTML, I need to push the output to a variable as a string for use ...
0
votes
0answers
66 views
CSOM get Folders in Root of Document Library in paged response
Apologies for reposting, I believed a question I asked last week was answered but I was incorrect. Trying to quickly learn CSOM and CAML to take over the management of an unmanaged document library.
...
0
votes
2answers
155 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
1answer
18 views
Rest query, get values IN a collection
I would like to get the items whose field A is IN (X,Y,Z...).
I've seen ways to do it with ORs (Rest API - $filter multiple values) but is there a simpler way?
Something like:
/_api/web/lists/...
0
votes
0answers
32 views
Get Author's email from joined list
Working on SharePoint 2016 OnPremise, trying to get the email of the author of an item, joining different lists. As an example let's take the following CSOM CamlQuery:
<View>
<Joins>
...
1
vote
1answer
12 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
1answer
44 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 ...
0
votes
1answer
299 views
Powershell Get List Items DataTable Group by on multiple columns/fields
I am trying to use PowerShell Group-by on the DataTable obtained from the SPListItemCollection. The reason for using the PS Group-By is because the CAML query groupby options do not return the ...
0
votes
1answer
30 views
CAML Query with multiple properties
I want to use CAML query to delete elements from a SharePoint list.
Right now it deletes element if they have a specific text in their title:
camlQuery.set_viewXml('<View><Query><...
0
votes
1answer
32 views
Query to filter RelatedItemID column using CAML
I have to filter RelatedItemID column from workflow task list using CAML query to get only those records that match the MAIN itemID from its corresponding main list. How do I achieve this? I tried the ...
0
votes
0answers
18 views
SharePoint 2016: Find all values of a site column across all sites in CSOM
I am trying to create a list of all the values that are being used for the site column "Classification" across all sites of a site collection. The idea is to build a dictionary to add to the term ...
0
votes
1answer
149 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()...
0
votes
0answers
18 views
Change Caml Query View/Filter using javascript button without reloading page
I have a script to pull a custom list using caml query, push it to html and format it with css to appear as a blog preview on our sharepoint homepage. When adding items to the list, users have the ...
2
votes
1answer
42 views
Is there a way to get the json content of files fetched through a CAML query?
const query = `<Where>
<Eq><FieldRef Name="File_x0020_Type"/>
<Value Type="Text">json</Value>
</Eq>
</Where>`;
const xml = '<View ...
0
votes
1answer
1k views
Retrieve data from SharePoint list via PnP JS and CAML Query
I wanted to display all files which have the property "Job" = "Job1".
How to retrieve list view items using PnP JS and CAML Query?
Here is the CAML Query?
<ViewFields>
...
0
votes
1answer
33 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
1answer
85 views
Getting ID for a list item with JS
I am trying to set up a simple subscription tool where users can subscribe to or unsubscribe from various distribution list. The idea is that you select a user through a people picker ('subuser'), ...
1
vote
0answers
29 views
CAML query for child properties
I have a CSOM query like this one:
_context.Load(currentItems,
lis => lis.Include(
i => i.RoleAssignments.Include(
ra => ra.RoleDefinitionBindings,
...
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='...
1
vote
0answers
18 views
On publishing sites, how does the user's preferred Display Languages preference affect page contents and CAML query results?
On an on-premise SharePoint 2016 farm with Language pack deployed, we see that users with different preferred Display Language (in their profile) get different results of CAML queries, different web ...
0
votes
1answer
53 views
SharePoint CSOM query against concrete subfolder is not working with RowLimit when thresold is reached [duplicate]
Can you please help with the following question. I have a document library with a lot of documents (>5000) which are organized in subfolders. I have to query all documents in subfolder. I use this ...
0
votes
0answers
379 views
Filtering documents on SharePoint Online Library folder in a different site
I have a mammoth document library with folders on a site. I'm trying to show specific files in these folders so this is how the original Library View displays:
I've migrated this over from a ...
1
vote
1answer
22 views
SharePoint 2010 CAML - Casting Date Fields?
So I'm trying to build a CAML Query in SharePoint to query a list where Date is greater than a certain value say 1/1/2016, my CAML looks kinda like this
<Where>
<Geq>
<FieldRef name = '...
