Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
940
questions
0
votes
0answers
12 views
_LikeCount and _CommentCount field is missing on CAM Query Request
Hi i am creating spfx webpart to display most liked and commented news however _LikeCount and _CommentCount not appearing on the result.
See below code:
props.topCount = props.topCount === undefined ? ...
0
votes
1answer
30 views
Caml Query - Unable to get data by date range
I have a list "List-A" which have an item with following details:
StartDate: 2021-08-31T22:00:00Z [In list view- 09/1/2021, type- DateOnly]
EndDate: 2021-09-29T22:00:00Z [In list view- 09/...
0
votes
1answer
10 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 ...
0
votes
2answers
40 views
CAML Query with multiple conditions
I'm trying to add another OR condition in my CAML Query below, but nothing seems to be working. Can someone help? Please see attached picture of the library. I am trying to get the highlighted data. ...
0
votes
0answers
17 views
Working CAML Query now returns 0 items
I have Windows scheduler running a job every week.
1)The job picks up items from a SharePoint Library filtered by CAML query
2)Updates system based on a column's value.
Recently; it has been found ...
0
votes
0answers
104 views
Caml Query on Sharepoint Online using Python
I am using Python to get the data from share point. I want to extract particular rows or data which has Status = "Submitted".
For that I have written below code but I am not sure why am I ...
0
votes
0answers
18 views
Camlex Query CSOM throws 400
I have a WSP that includes Camlex.Client 1.4, the WSP contains the DLL and targetDeployment is in GAC. On the server, the GAC contains the DLL.
I have a REST Service that connect to my ...
0
votes
0answers
32 views
SharePoint column dynamic filter not working
I am use Query String URL to get param and filter library view.The param works and show exact files.But after use {param} not show column header filter values on my library
0
votes
1answer
21 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.
0
votes
1answer
205 views
RowLimit not working in PowerShell Get-PnPListitem
I am trying to get few items from SharePoint list so I am using RowLimit in a query, but it doesn't seem to work.
$query = "<View><Query>
<Where><Eq> <FieldRef Name='...
0
votes
0answers
24 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....
0
votes
2answers
36 views
Unable to Access multidimensional array elements of SharePoint CAML query
The following code outputs a comma separated array for the var cats. The array has six items as the list "banner" has two columns and three rows of items. I can access the array items in the ...
1
vote
1answer
29 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 ...
1
vote
1answer
39 views
CAML query is returning all the list items
I have the following CAML query
CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<Query><Where><Eq><FieldRef Name='RiskRequestID'/><Value Type='Text'>&...
0
votes
0answers
35 views
CAML Query to filter out document sets based on values of Content Type
I have a document library with document sets that have Content Type (Name of Content Type is "FruitCategories") columns as "FruitName" (single line of text), "FruitPrice" ...
0
votes
0answers
71 views
convert folder to document set using powershell
I am trying to convert folders to document sets. As there are a lot of folders and many libraries spread around many subsites, I am querying items based on a specific content type and then converting ...
1
vote
1answer
185 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 ...
0
votes
1answer
72 views
SharePoint search query: display people from a specific AD group
I want to display all members / users who are in the Active Directory group "Marketing".
What do I have to add / change to the following query so that I don't see all users, but only those ...
0
votes
0answers
26 views
Filter lookup field of multiple values using REST API 'getitems'
I am trying to retrieve items from a List, using CAML+RESTApi but when I try to $filter for a lookup column with multiple values it shows me:
{"error":{"code":"-1, Microsoft....
0
votes
2answers
30 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><...
0
votes
0answers
17 views
CAML for a file with no base name
I'm trying to find a way to write a CAML query that checks if a file with empty base name exists.
For example:
.gif
.png
.jpeg
Where the part before the extension is an empty string.
You can see ...
2
votes
1answer
99 views
SharePoint 2013 Caml Query on GUID using CSOM returns empty
I'm trying to find a file in a folder by GUID. There is a reason behind it, because I get GUID in document set history and I cannot rely on a file name.
I'm stuck trying all the possible combinations ...
1
vote
1answer
47 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() {
//...
0
votes
1answer
149 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
55 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
44 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
127 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 ...
1
vote
1answer
36 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
55 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
23 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
14 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
3answers
85 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
27 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
64 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
53 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
1answer
564 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
43 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
422 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
1answer
410 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
249 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
42 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
61 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
48 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
1answer
23 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
665 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
301 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
25 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
14 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
335 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
54 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 ...
