Questions tagged [caml-query]

An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

Filter by
Sorted by
Tagged with
0 votes
1 answer
24 views

caml query to get events that occur next day

I am creating a timer job for SharePoint 2016 on premise calendar event task. The function is to send reminder email to event attendees 1 day prior to event occurrence. I am creating a timer job to ...
0 votes
1 answer
11 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><...
  • 43
0 votes
1 answer
37 views

'See all' link with custom CAML query

With Sharepoint online (highlighted content) : Using a working CAML Query with Rowlimit, I've lost the "see all" link that is showed by default when I display without the query. As soon as ...
0 votes
0 answers
9 views

CAML filter in library: check group membership not based on a field value

I have currently a list which I would like to filter. The filter clause would be something like this in pseudo code : If CurrentUser is member of GroupAdmin then show library item Or If CurrentUser is ...
0 votes
1 answer
19 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
0 answers
22 views

Javascript: Correct Syntax to find if string exists in Array

In the DO..WHILE loop I need to extract 5000 items from a list (LookupList) and create a new list (arrayAll). I need to extract 5000 at a time as SharePoint has a limitation of 5000 items. I need help ...
  • 101
0 votes
0 answers
24 views

How to filter CAML Query Results

How can I modify this code so that it displays only the records where the title equals whatever the current title is of the current record I am in? Currently I get all the records from the second ...
0 votes
1 answer
33 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', ` ...
0 votes
0 answers
19 views

CAML query (SP 2013) - Is there any limit to AND operator

I have to following CAML query. I need to add one more boolean field but it's not returning result. Original CAML <Query> <Where> <And>...
0 votes
1 answer
29 views

Highlighted content web-part should show data based on current logged in user's location

I want a webpart that shows Events/Holidays based on the current user's location. I'm using the Highlighted Content web part. I've filtered only on ContentType:Events and scope is on whole site. How ...
0 votes
1 answer
340 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
243 views

RenderListDataAsStream Rest API not returning Field in ViewFields

RenderListDataAsStream is not returning some fields specified in ViewFields. I need to retrieve ServerRedirectedEmbedUrl but doesn't return anything. If I run the following CAML Query specifying the ...
  • 1
0 votes
1 answer
27 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
0 answers
30 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 ? ...
  • 709
0 votes
1 answer
88 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/...
  • 785
0 votes
1 answer
18 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
2 answers
242 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. ...
  • 3
0 votes
1 answer
35 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
1 answer
980 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
0 answers
71 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....
  • 982
0 votes
2 answers
44 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
1 answer
89 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 ...
  • 141
1 vote
1 answer
107 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'>&...
  • 982
1 vote
1 answer
723 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
1 answer
232 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
2 answers
74 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
2 votes
1 answer
224 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 ...
  • 23
1 vote
1 answer
57 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
468 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/ ...
  • 153
0 votes
1 answer
112 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
2 answers
68 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 ...
  • 307
0 votes
1 answer
207 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
1 answer
123 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
1 answer
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, ...
  • 641
0 votes
3 answers
286 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>&...
  • 1
0 votes
1 answer
30 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 ...
  • 111
1 vote
1 answer
154 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
1 answer
70 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
1 answer
963 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
1 vote
0 answers
67 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
1 answer
759 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
1 answer
748 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, ...
  • 163
0 votes
1 answer
427 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}/`+...
  • 97
1 vote
2 answers
74 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
1 answer
111 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
2 answers
62 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
1 answer
27 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 =...
  • 614
0 votes
2 answers
991 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
0 answers
448 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
1 answer
33 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 ...

1
2 3 4 5
19