Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
902
questions
0
votes
2answers
37 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.
...
1
vote
1answer
770 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
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 ...
2
votes
1answer
805 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 ...
0
votes
0answers
28 views
DIfference between camlQuery.AllowIncrementalResuts=true and camlQuery.AllowIncrementalResuts=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
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 ...
26
votes
4answers
38k views
CAML query limitation of values in IN operator
I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query.
<Where>
<In>
<FieldRef Name="ID" />
<Values>
<...
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
21 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 ...
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
19 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 ...
0
votes
0answers
38 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
1answer
24 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
2answers
31 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
13 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
30 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
11 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 ...
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
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 ...
1
vote
1answer
20 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
60 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 ...
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 ...
0
votes
2answers
748 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, ...
1
vote
2answers
5k views
SharePoint CAML query to retrieve the item more than threshold limit
I facing a problem while retrieving the list data from SharePoint online. I have list items around 20,000. I am using a caml query to retrieve the data based on conditions in dotnet csom. it has 5300 ...
0
votes
1answer
19 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><...
1
vote
1answer
679 views
Programmatically get pages which are created using custom page layout
I have custom ArticlePage.aspx page layout.
I have created some pages in Pages library using ArticlePage layout.
Now programmatically. I'm trying to get that pages with their properties.
I did ...
0
votes
1answer
23 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
2answers
791 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
14 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
761 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 ...
1
vote
2answers
909 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
1answer
57 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()...
3
votes
1answer
727 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-...
0
votes
1answer
842 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
2answers
784 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....
2
votes
2answers
778 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 ...
0
votes
1answer
858 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 ...
0
votes
0answers
14 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
30 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
304 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>
<FieldRef Name='...
0
votes
1answer
29 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
82 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
25 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
32 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='...
17
votes
6answers
81k views
Get Items Under Folder CAML
I am trying to retrive all items that are under a certin folder, in a document library.
this is what i have so far
List DocumentsList = clientContext.Web.Lists.GetByTitle(list);
CamlQuery camlQuery ...
1
vote
0answers
17 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
29 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 ...
7
votes
1answer
6k views
CAML query recurrent events problem
Here is the code I use:
SPQuery query = new SPQuery();
query.ExpandRecurrence = true;
query.CalendarDate = new DateTime(2013, 1, 1);
query.Query = @"
<Where>
<DateRangesOverlap>
...
0
votes
0answers
157 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 ...
