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

1
2 3 4 5
19