Stack Exchange Network

Stack Exchange network consists of 175 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
1answer
24 views

How to print the result of caml query?

I've got a list with 2 columns col1 and col2. I wrote a CAML query and I want to print the value from the second column corresponding to the value from the first using (SPSite site = new SPSite(...
0
votes
1answer
25 views

javascript plugin working only ctrl+F5

im test new template and using camljs lib. next step to read javascript not work a loop, becouse read htmlcollection aint return length. i can view returns only refreshing with ctrl+F5 or ctrl+shift+...
0
votes
1answer
29 views

how to change caml query with condition <OR> for 5000+ list items

I have this CAML query that wouldn't work if i change it to but works with HOWEVER. since our list no has 15k items using OR doesnt work. basically this remote event receiver gets list items with ...
1
vote
1answer
18 views

Retrieve a Value From A List Based On Who Is Logged In

I currently have the vacation days for all the employees saved in a SharePoint list. I would like to display the number of vacation days the employee that is logged in has on the Home page. For ...
0
votes
1answer
45 views

CAML filtered list views - filter more than one nested level?

do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups? I've ...
1
vote
1answer
34 views

CAML Query with more than one condition

Hi I am currently writing a sharepoint add in application which reads and writes to sharepoint lists. For one of the lists I want to retrieve a list item based on the user logged in and also based on ...
1
vote
1answer
50 views

CAML query returns different data

I created a CAML query that I need to use as a workaround for REST API and the 5k threshold limit: However when I was testing it using the SharePoint CAML Query Helper Online, it returns the correct ...
0
votes
2answers
31 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
20 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
3answers
87 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
39 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
55 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
32 views

SharePoint 2010 GetListItems - Problem with CAML Query

This works "<Where>" + "<And>" + "<Geq>" + "<FieldRef Name=\"StartDate\"/>" + "<Value Type=\"Date\">" + DateTime.Now....
0
votes
2answers
287 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
47 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
85 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
35 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
29 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
44 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
77 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 | |...
-1
votes
0answers
16 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
34 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
196 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
208 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
1answer
66 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
123 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
135 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
702 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
42 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
56 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
38 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
32 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
153 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
178 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
3k 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 ...
1
vote
2answers
305 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 ...
4
votes
1answer
881 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
149 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 ...
2
votes
2answers
392 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
173 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
466 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
185 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
97 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
543 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
152 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 ...