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
1answer
40 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
0answers
26 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
vote
0answers
30 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
32 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
29 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, ...
-1
votes
0answers
29 views

Filter between 2 chosen parameter dates CAML

I have a CAML query in my site page containing mulitple list web parts that will filter based on a begin date and an end date calendar control on the page. The end user chooses this range and the web ...
0
votes
1answer
64 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
28 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
30 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
42 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
0answers
14 views

Unable to query SharePoint list by date using CAML and PowerShell

I am trying to use a CAML query through PnP powershell to get a list of items. My code looks like this: $today = get-date -Format "yyyy-dd-MM" $today = $today + "T00:00:...
0
votes
1answer
19 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 =...
0
votes
2answers
87 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
0answers
97 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
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 ...
0
votes
1answer
25 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 ...
1
vote
1answer
35 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
0answers
45 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
2answers
66 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
16 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 ...
1
vote
1answer
28 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
142 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 ...
0
votes
1answer
23 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
28 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
0answers
16 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
91 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()...
0
votes
0answers
17 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
34 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
656 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
30 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
83 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
27 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
33 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='...
1
vote
0answers
18 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
35 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 ...
0
votes
0answers
256 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 ...
1
vote
1answer
19 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
150 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 = ...
0
votes
1answer
100 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
118 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
165 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 ...
0
votes
1answer
101 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
189 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 ...
1
vote
1answer
44 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
52 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
1answer
19 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='...
0
votes
1answer
62 views

If Else in the CAML Append Method

I have been trying to do an if else condition in the append method however for some reason it's not reading the condition. Here is the code. Towards the bottom I want to show signNow if the list ...

1
2 3 4 5
19