Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
927
questions
1
vote
1answer
913 views
using SSRS to generate a report based on a Calendar in Sharepoint 2013
We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to ...
2
votes
1answer
821 views
Manage files with no checked in version - CAML query
I am using Office 365. We have a document library containing more than 12000+ documents, with a number of folders and subfolders.
I need to find a way to get all document which have no checked in ...
1
vote
1answer
2k views
How to count SharePoint list elements using CAML Query
I have got CAML Query. How to count how many elements is in the list checked ?
Here is javascript code:
var siteUrl = '/sites/MCUW-IT/kostka-pilotaze/restauracje-pilotaże/';
var clientContext =...
0
votes
1answer
34 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
15 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....
1
vote
2answers
1k views
How to use CAML query with rest
I am trying to get list data with an id from my SharePoint online through REST. I have my ajax call like below.
getFunction:function(id){
return new Promise(function (resolve, reject) {
$.ajax({
...
0
votes
2answers
17 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
15 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 ...
0
votes
1answer
1k views
Document Library File GUID
I used a CAML query to get file information in a document library.
In the CAML query I get the GUID in order to get the unique id of the document.
<FieldRef Name='GUID'/>
In a different ...
0
votes
2answers
1k views
SP.CamlQuery().set_viewXml() returns undefined
I am trying to run a CAML query to sort through some data. Once the page finishes loading i do not get the results i want. I checked the functions and it turns out that for some reason, my CAML query ...
0
votes
1answer
208 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 ...
2
votes
1answer
29 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
41 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() {
//...
2
votes
4answers
2k views
Sp Services and calendar list
I have a SP Service call which uses GetListItems from a calendar list in SharePoint. I'm using it with the FullCalendar plugin. The events render fine that is not my question, my question is this:
Is ...
0
votes
1answer
48 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
2answers
33 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
29 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
1answer
37 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
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 ...
6
votes
1answer
2k views
SPServices Autocomplete and dynamic CAML query
I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
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>
...
1
vote
2answers
1k views
CAML Query for retrieving only document library items in only one folder
I'm trying to access the documents in a specific folder in a SharePoint document library. the library has multiple folders but I do know the name of the folder.
here is an example of the file tree (I ...
1
vote
2answers
785 views
Filter and Sort the List with Caml Query
We are required to display the list data based on below 3 conditions for the based on 3 columns (Customer Category, Test Type ,Exercise Result) and sort with column (stage Plan) .
1. Customer ...
0
votes
1answer
2k views
Add filter and pagination to CAML query
I'm developing a visual web part for Sharepoint 2010.
I would display all documents from a specific DL, but this DL contains more than 7000 items.
So I would like to add a pagination (show only 20 ...
0
votes
2answers
763 views
SharePoint SPServices query and sum list items
I have 3 dropdown menus, in those 4 fields I have choices to query a SharePoint 2010 list using SPServices
Dropdown filters are: Year, Month, Company
List fields are: Year, Month, Company, ...
0
votes
2answers
884 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....
0
votes
0answers
36 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
2answers
844 views
Update filed values based on conditions
i have document library in sharepoint 2010 and i want to update a field values based on some conditions .
I need that every parentid has some documents and i want to update those prosessnos which ...
0
votes
0answers
10 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
1answer
891 views
Concatenating a javascript variable into a camlQuery
I have a caml query that I'm concatenating with a javascript variable of type string. It queries the column names 'Audience' and returns the first 3 ordered by the newest.
The variable subsite gets ...
0
votes
1answer
768 views
How to write Join 4 lists using CAML Query (CSOM)
I have four lists in my site. I need to get data from all these lists in CSOM (Provider hosted app). All these lists are connected linearly (one to one).
List 1 -> List 2 -> List 3 -> List 4.
for eg ...
0
votes
2answers
971 views
sharepoint CAML query in Ascending order
we have webpart that fetch the data from the sharepoint list
camlQuery.set_viewXml("<View></View>);
now i am trying to do sort the display by enddate (ascending order)
camlQuery....
3
votes
1answer
736 views
CAML batch query - valid XML?
The standard format of a CAML batch query is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<ows:Batch OnError="Continue">
<Method ID="">
<SetList>288a3dfc-ec52-45aa-...
2
votes
1answer
1k views
Sharepoint CAML IN operator not working with FileDirRef
I want to retrieve a list of file from two folders.
When I combine two <Eq><FieldRef Name="FileDirRef" />... with <Or> it works fine.
When I want to use the <In> operator it ...
0
votes
1answer
910 views
How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?
I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items.
The dataset is only returning items from the ...
2
votes
2answers
786 views
Multiple CAML query to filter Data list view
My Custom list has four columns(Doc ID, Created by, Assigned To, Assigned date). I want to filter the data in Data list view.
In my page, there are 4 text boxes and a Button is there for the user ...
3
votes
0answers
189 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
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 ...
2
votes
2answers
3k views
How to query the list using CAML Query to List's multi allow user field?
I have a list in which there is one column which is of type People or Group with multi allow. I have created Item Adding event receiver in which I am checking the entered people value is already ...
1
vote
1answer
37 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>&...
1
vote
0answers
36 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
121 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
159 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
145 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
35 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
41 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 ...