Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
891
questions
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
8 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
642 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
22 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
750 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
13 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
755 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
800 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
28 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
725 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
823 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
729 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
777 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
830 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
12 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
29 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 ...
2
votes
1answer
962 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
58 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
27 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
739 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 ...
1
vote
1answer
80 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'), ...
2
votes
1answer
802 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
0answers
20 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='...
16
votes
6answers
78k 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
16 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
21 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
64 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 ...
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 ...
1
vote
1answer
17 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 = '...
0
votes
1answer
69 views
CSOM CAML Query - is there a returned fields limit?
I've just noticed that that there is a difference in result when searching for a list item with CAML Query and getting it by ID.
Following piece of code returns item with 100 FieldValues:
var item = ...
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
33 views
Getting and setting multiple items from a Sharepoint list using CAML query?
I have a SharePoint list Catalog.
Using camlQuery I can get a list item value called Price.
With the following code I get the Price value of the list element which has the ID 5 and store it in a ...
0
votes
1answer
52 views
How to retrieve the SP list items without using CAML Query?
I have a SharePoint list and I need to get all items from that list without using CAML Query in JSOM.
How can I do this?
1
vote
1answer
75 views
Error retrieving items from large list, although the CAML query has a row limit
I'm able to use a console application to connect to a SharePoint Online large list (more than 5,000 items) and retrieve the title. However, even though my CAML query has a row limit, I still get an ...
1
vote
6answers
9k views
Filter list data using SPServices, CAML Query, and dropdown list
I'm trying to create a table using SPServices to fetch the data, and filter it using CAML Query and a drop down list. I would like to create three conditions:
A. If no item from the list is selected, ...
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
44 views
Query a single line of text filed using CAML <Contain> will return all items
I have a list inside SharePoint online site collection. the list contain a field named Processed which is of type single line of text, and only one item have a value inside this field while the other ...
0
votes
1answer
61 views
CAML Query Help - O365 Sharepoint with Managed Metadata
I'm trying to display only documents from a library named "How to get it done" and I want to show all document types that have the Managed Metadata tag of "HFM".
Some of my documents have multiple ...
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
2answers
791 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
1answer
37 views
Binding certain value from SP List to DropdownList
I am currently trying to grab certain values(choice column) from a SP list into a DropdownList in Visual Studio, for example, currently in the SP List choice column, there're 5 choices altogether but ...
0
votes
3answers
41 views
CAML error when querying SharePoint List for more than one input
I have a CAML query which retrieves data from a SharePoint list. It passes for 1 input, but fails when there are 2 or more.
Error:
Microsoft.SharePoint.SPException: One or more field types are not
...
0
votes
2answers
733 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
1answer
17 views
Query Modified Date
I found tons of samples with query for modified. But following keeps giving an exception that the query limit was to large (I gues it is the threshold limit).
var query =
$@"<View Scope='...
2
votes
5answers
12k views
CAML Query Filtering with OffsetDays
I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this:
If a date is not specified on the Query String, then show me items
created in the last 30 days
If a date is ...
1
vote
1answer
611 views
CAML query - examine Contents column used in freetext predicate
In my query I use the freetext predicate:
and freetext(Contents, 'my search string')
I'm getting some unexpected results from this search, namely the documents contain no relevant content, yet are ...
2
votes
3answers
97 views
How can i add CAML query to my page?
Sorry for this basic question.I want to read list items. I will use CAML query . But i dont want to use Visual Studio and C#. Is there any way to do this?
