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
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?

1
2 3 4 5
18