Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [caml]

Collaborative Application Markup Language (CAML) is an XML-based language that is used in Microsoft SharePoint Foundation to define the fields and views that are used in sites and lists.

0
votes
2answers
26 views

SharePoint List Query fails with error “Request failed, cannot complete this action”

I'm trying to query a SharePoint list on my root site collection but keep getting the error "Request failed, cannot complete this action". I messed around with the CAML query below and have figured ...
0
votes
2answers
18 views

Is there a sotfware to create, manager and CAML query SharePoint Lists without having SharePoint installed on a computer?

I'm working on a SharePoint site at work, however due to PCI compliance I am not able to access SharePoint at my house, I was trying to find a software on which I can be able to create lists and use ...
0
votes
2answers
71 views

caml query won't return rows with null value in contains query

I have written a CAML query using <Or> with <Contains>. the query looks similar to below. <Where> <Or> <Or> <Contains><FieldRef Name="Field1" /...
0
votes
1answer
38 views

How To: Filter A Query on All Lists Based on Title Contains

I have queried all of the lists within a subsite but need to filter based on criteria in the title. I then need to display the filtered list contents. Is this possible if the list contents are not ...
0
votes
4answers
50 views

How To: Query & Display items from ALL lists within a subsite

I am looking to query and display items from all of the lists that exist (and will exist in the future) on a specific subsite (SP 2013). Below is what I have so far but it is not producing any alert,...
1
vote
1answer
27 views

SharePoint 2010 GetListItems - Problem with CAML Query

This works "<Where>" + "<And>" + "<Geq>" + "<FieldRef Name=\"StartDate\"/>" + "<Value Type=\"Date\">" + DateTime.Now....
0
votes
2answers
148 views

How to load all list items using caml query?

I'm using SP 2013. And I have a Wiki Page Library. I try to load all items from this list. I'm using the following code: var context = new ClientContext("SiteUrl"); context.Load(context.Site); ...
1
vote
1answer
40 views

JQuery / CAML Undefined Error

I found some code on line, see below, and changed it to meet my needs but when I run it I get: Due Date undefined This is the only value in the list, but it should look like: Due Date 01/31/2019 ...
0
votes
1answer
38 views

CAML Query : Where clause not working with View tag & RowLimit

I've reached the maximum view threshold limit on a SharePoint List, with a little more than 5000 item in it. When I raise the limit in the webapp's settings, everything is working fine, but I would ...
0
votes
3answers
32 views

caml query that searches for specific records

hello everyone form this query to find column records until this moment works for me but when I want to add that look for other records of the column department gives error I would appreciate your ...
0
votes
3answers
28 views

When running a CAML-Query without OrderBy: Are IDs always incremental?

I want to bulk load a few items from a list. The Caml is something like this: <View><Query><Where> <Gt><FieldRef Name=\'ID\'/><Value Type=\'Number\'>{id}</...
1
vote
1answer
41 views

Get the list specific rows from sharepoint where value exist

I am working in c# and I have a list of strings which contains the projectid of the SharePoint list List<string> guidlist = new List<string>(); // contains project ids On the basis of ...
0
votes
0answers
22 views

CAML query inside my List view which contain 19 critiria is not working

I want to create a list view inside sharepoint on-premises team site. the list view need to show items which are under any of the 18 customers + that are not Expired.. so i wrote the following CAML ...
1
vote
2answers
63 views

CAML: Not in Group

Building a CAML query in SP. Want to result item where current user not in group that is in the AssignedTo field. Tried wit Neq, NotIncluded: <View> <Query> <Where> <...
0
votes
0answers
9 views

Two lists with Site, one with site number, and one with column with many site number Need Assistance

I have got two lists one with one site number in record, and one with many site numbers in one column: -------------------- --------------------------------- | Site | Name | |...
0
votes
0answers
14 views

Removing delimiters while exporting a list to an HTLM table

I am trying to use SPServices to display a list as a custom HTML table. I used the solution given here: https://sharepoint.stackexchange.com/a/137446/77551 So far, so good, but user names on my list ...
1
vote
1answer
31 views

CAML Query Dynamics with SPServices

I'm developing a web application using SPservices for interaction with Sharepoint lists. My question is on how to create a dynamic Caml Query using the And and Or conditions. The condition below ...
0
votes
1answer
108 views

Get files modified or added yesterday from SharePoint document library

I am trying to get all the files which is modified or added yesterday from SharePoint document library using below code. List list = clientContext.Web.Lists.GetByTitle(listName); ...
2
votes
1answer
155 views

Include All day events in CAML query for a date

I'm querying SharePoint for calendar events given a date. This works for events other than all day events. Event dates in SharePoint are stored as UTC except for all day events which are stored as ...
0
votes
0answers
49 views

GetItems REST Call from Designer Workflow

I need to pass a parameter to a stored procedure through a BCS connection and external list. So I am doing a post call to GetItems from a Sharepoint Designer 2013 workflow. Response code is ...
0
votes
1answer
40 views

Unable to get exact result for CAML Query

I am trying to execute below condition in REST , But OData in Rest doesn't support null . I would like to execute below condition in CAML Query and Pass to REST. Tried using CAML Query ,But I am ...
0
votes
1answer
94 views

Unable to Query list's items using Rest API + CAML. Error “One or more field types are not installed properly…”

I want to query my custom list using REST API + CAML. And I have to use POST request to be able to get the managed metadata values (mainly Label), so I tried the below Ajax request: var body = { ...
0
votes
0answers
92 views

Get two items from same list in a single CAML query

We have a list with following fields: FlagField : Yes/No DateField : Date only I need to fetch two items from the list One where FlagField is set to Yes and DateField is latest (Descending order) ...
0
votes
1answer
538 views

Sharepoint Online CAML query very large list checked out files, csom powershell or c#

I have poured over a ton of posts and code and none seem to work with checked out files and really large lists. I am newish to sharepoint, especially online. I moved a doc repo up there for testing ...
0
votes
1answer
41 views

How to get all documents in given Documents Set in SP2016 using JSOM?

I have client-side Javascript on a SharePoint page. It must change the Title of every Document present in a specific Documents Set. That Documents Set is one of many, in a huge documents library (...
0
votes
0answers
52 views

CAML Query Type as text, show all items

I have this query camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>21094460</Value></Eq></Where></...
0
votes
0answers
31 views

CAML Query to Limit Lookup Field

I am creating an SSRS report based on a SharePoint 2016 list using the following query: <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/...
0
votes
0answers
31 views

Access Sharepoint 2010 column SETTINGS with jquery& SPServices

I need to access column properties with jquery/SPServices from client side. For instance, I have the below code. The below works perfectly, it allows me to access all rows and loop through them the ...
0
votes
0answers
33 views

How can i fetch custom list columns with javascript?

I created a list and it has got GroupName and EmailName columns. I want to fetch the data but this code is not working. How can i solve this? var GroupName=$(this).attr("GroupName"); all the ...
0
votes
0answers
12 views

Stop breaking my views!

I have a complex query that is using a filter on a Hyperlink field. These have to be done by creating the CAML query within the view's .aspx. SharePoint Designer => Lists => ListName => ViewName =>...
1
vote
0answers
126 views

CSOM (HighTrust) SP2013 Group by aggregate giving duplicates

Hi I've been reading about group by in SharePoint 2013 CSOM from this article here. https://piyushksingh.com/2016/11/21/retrieve-grouped-listitems-sharepoint I've recently upgraded to 2013 and though ...
0
votes
0answers
21 views

CAML Query to provide library view access to site collection admin along with users belonging to a particualr group

Can some one give the CAML Query to provide library view access to site collection admin along with users belonging to a particular group. Rgt nw when i use below code: <Or> <Membership ...
1
vote
2answers
150 views

CAML query cant read serverrelatedURL with special character

My scenario : I am using a caml query to read all folder and files in a list but i noticed that if i get a folder by serverrelativeURl and the list name is(eg késhév,ie has special character or a ...
0
votes
2answers
2k views

Get all items of a Folder and subfolders using csom [duplicate]

My scenario: I need to update 2 columns of items in a certain subfolder.But here the subfolder can contain subfolder and so on which i need to update too.I am using csom to try to accomplish that.I ...
0
votes
0answers
12 views

Wrong SOAP result?

I got a list in Sharepoint. I created a query in U2U Caml.There are 39 items in this list. I am trying to show this items in website.I am using the same query. But there are 30 items that the query ...
1
vote
2answers
242 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 ...
3
votes
1answer
748 views

How to Group by the Column using CAML Query

My requirement is to get the unique values from the column "Month" I am using the below code to group the column "Month" , But I don't find any luck .Can any one tell me what's wrong in my below code ...
0
votes
0answers
123 views

CAML Query on value ending with space

I have the following CAML query: <Where><Eq><FieldRef Name="Title" /><Value Type="Text">TestDocument </Value></Eq></Where> I have an item in the list with ...
0
votes
0answers
109 views

Create a List view with joins and projected fields

is it possible to create a List view with joins and projected fields? Looking at the properties of a view I can see that there a properties for ProjectedFields, ViewJoins etc. So I thought I give it a ...
2
votes
2answers
318 views

Sharepoint 2013 Check if path folder exists

I have a query like this: camlQuery.set_viewXml('<View Scope="RecursiveAll"><Query><Where> <In><FieldRef Name="FileDirRef" /> ...
0
votes
1answer
159 views

CAML query incorrectly returns all items

I am querying a list with this CAML Query: var camlQuery = @"<Query> <Where> <Eq> <FieldRef Name='...
0
votes
1answer
362 views

How to pass variable value in CAML query?

I have a Dropdown list, I want to pass selected value of this dropdown to caml query. Please suggest solutions for this SharePoint online query.
1
vote
2answers
151 views

How to insert CAML query into SharePoint site?

I am trying to insert some CAML into my site and I am not sure how to do so. I have been looking around at the available Web Parts (and other areas) to allow me to add a CAML query to my site, but I ...
0
votes
1answer
80 views

MultiLookup column and CAML query

How to create CAML query to find items which have all specified lookup values? The query below returns items which have item1 or item2, or (item1 and item2). But I would like to return only items ...
5
votes
2answers
483 views

CAML Query Logics

For this below logic, how to write a CAML query? Kindly guide me. Query Logic: where department ='HR' And (Team='A' Or Team ='C' Or Team ='D') Here "department" and "Team" is column name and ("HR",...
1
vote
0answers
120 views

CAML Query to get filename with the corresponding DocumentSet

I have a document library with Document Sets, and inside document sets I have files. I need a CAML Query to return ONLY the files, but I need to know to which Document Set each file belongs to. I am ...
1
vote
1answer
383 views

CAML - Get Items Under ALL existing Folders

I have about 10 Document folders in my list 'ZooLibrary' and I would like Query to display all the PowerPoint files title from the folders in the list, sorted by ID. Currently, my View Scope='...
1
vote
1answer
238 views

Caml query for multiple status

I want to create a CAML Query like this (status= waiting for approval && Requestor Manager = UserID)or(status= stage2 && Approver= UserID) Please let me know what i am wrong here &...
1
vote
1answer
39 views

JS: If 'X' is mentioned anywhere in the LIST. Display

My list categories: Cats Dogs Cats and Dogs What i want to achieve: If 'Cats' is ANYWHERE mentioned in the list field, display data in HTML table. This means category Cats Cats and Dogs will ...
0
votes
1answer
224 views

Display CAML Query Results in Existing Webpart using JavaScript

I am probably missing an obvious solution but after spending a couple of days on this topic I'm a bit stuck. The scenario I have is a site page with Content Editor Web Part (CEWP) and a Document ...